Microsoft Excel Question: Download Questions PDF
I want to add a toolbar to my spreadsheet that when clicked, brings up Userform1?
Answer:
Assign the toolbar button to this macro, which should be in a standard VBA module:
Sub ShowForm ()
Userform1.Show
End Sub
Sub ShowForm ()
Userform1.Show
End Sub
Download MS Excel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| I want to show a userform each time my file is opened? | How do I run a macro every time a certain cell changes its value? |