I want to know if anyone can suggest an approach to a macro that will generate a dialog box, on opening a workbook, that will present a series of buttons (radio, 3D, whatever) that are linked to worksheets, such that when the buttons are activated, the user is taken to an appropriate worksheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro for Dialog Box with buttons that select a worksheet...
- Thread starter Todd K
- Start date
GeorgeAdamson
New Member
- Joined
- Feb 24, 2002
- Messages
- 14
I'll assume you're using VBA and know a wee bit about macros...
To create a form, go to the VB Editor in Excel using Alt+F11. Right-click on the Project pane and choose Insert...UserForm. Add buttons to the form. Double-click a button and type Sheets("Sheet2").Select replacing Sheet2 with the name of whatever sheet you want to activate.
To make the for run when you open the spreadsheet, add the following code to Module1
Public Sub Aut
pen()
UserForm1.Show
End Sub
To create a form, go to the VB Editor in Excel using Alt+F11. Right-click on the Project pane and choose Insert...UserForm. Add buttons to the form. Double-click a button and type Sheets("Sheet2").Select replacing Sheet2 with the name of whatever sheet you want to activate.
To make the for run when you open the spreadsheet, add the following code to Module1
Public Sub Aut
pen()UserForm1.Show
End Sub
Upvote
0
Similar threads
- Question
- Question
