vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

VBA

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:

=IsText (A1)

where A1 is the first cell in the range.
6. Click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.