Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selectively running macros on open
Thank you, Gary's Student. I'll do that.
John "Gary''s Student" wrote: There is undoubtedly a userform that can suit your needs. I, however, know nothing about these things. If no one updates this post further, then open a new post requesting help on a drop-down userform. -- Gary''s Student - gsnu200817 "Brenner" wrote: Thank you, Sir! Is it possible to put a drop down list box in the input message? Thanks, John "Gary''s Student" wrote: Private Sub Workbook_Open() Dim x As String x = Application.InputBox(Prompt:="Enter Site", Type:=2) If x = "Texas" Then Call cows End If If x = "Vermont" Then Call maplesyrup End If End Sub or use Select Case -- Gary''s Student - gsnu200817 "Brenner" wrote: As the workbook is open, I need to display an input box where the user can select which site they are from. When they pick their site, I need for the workboook to run macros that sort, filter, calculate based on that specific site. How do I create an input 'box', where the user can select their site - click ok - and then run the macros based on that input? All ideas and suggestions are welcome... Kindes Regards, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open workbook from code without running macros | Excel Programming | |||
Open workbook from code without running macros | Excel Programming | |||
Open workbook without running Macros | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming |