Fri 18 Sep 2009, 16:37Delegate Martin said...
Martin has attended:
Excel VBA Intro Intermediate course
VBA
Getting form to appear on excel spreadsheet
Tue 22 Sep 2009, 16:26Trainer Simon said...
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
