98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
VBA
Resolved · Low Priority · Version 2003
Martin has attended:
Excel VBA Intro Intermediate course
VBA
Getting form to appear on excel spreadsheet
RE: VBA
Hi Martin,
Thank you for your question.
Are you referring to adding a button on your excel spreadhsheet to run the form you created on the course?
Using the Control Toolbox, add a Command button to the spreadsheet. On the control toolbox toolbar make sure you are in Design mode.
Right click over the button and choose View Code. Type the following within the sub procedure:
frmInterface.Show - with frmInterface being the name of the form.
I hope this answers your question.
Regards
Simon
Tue 29 Sep 2009: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Validating text entries1. Select the range of cells.
where A1 is the first cell in the range. 6. Click OK. |