⟩ I want to add a toolbar to my spreadsheet that when clicked, brings up Userform1?
Assign the toolbar button to this macro, which should be in a standard VBA module:
Sub ShowForm ()
Userform1.Show
End Sub
Question and Answer:
Home MS Excel
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
When a button is drawn onto a sheet the assign macro is not displayed. When right-clicking on the button the "Assign Macro" context menu item is not present?
How do I run a macro every time a certain cell changes its value?
I want to show a userform each time my file is opened?
Is there a way to protect the macros I create so people can not see or alter them?
Is it possible to call a macro from the condition true or false side of a worksheet formula? i.e. If(A2="OK",Run macro1,run macro2)?
How can I save a chart as a GIF file?
How can I print a workbooks full path in the header or footer? The Page Setup dialog box does not seem to offer the option.?
How can I enter the current date into a cell so it does not change from day to day? When I use the NOW function, it always shows the current date?
I need to determine the difference between two times. If the difference is positive, it works fine. But Excel does not want to display negative time values. Why not?
Is it possible to determine the day of the week for a particular date?
