Assigning Command buttons to userform in 2003 | Excel forum

Resolved · Medium Priority · Version 2003

Thu 23 Dec 2010, 14:37 Delegate Martin said...

Martin has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Assigning Command buttons to userform in 2003

Hi,

I was recently on the VB course using Excel 2007. Now I am back at work I am using 2003. How do I link a command button in Excel 2003 to a UserForm in VB? I can easily select Macros to run, but I want the command button to launch the interface.

Thanks

Tue 4 Jan 2011, 12:05 Trainer Anthony said...

RE: Assigning Command buttons to userform in 2003

Hi Martin, thanks for your query. On our course our interface was called "frmMainInterface". When you have created the button on the spreadsheet, try double clicking on it (this will only work if you are in Design Mode). A click event subroutine will be created and the line of code you need would be:

frmMainInterface.Show

Back on the worksheet, activate the switch by coming out of Design Mode. It should be working now.

Hope this helps,

Anthony

Mon 10 Jan 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips