Selectively running macros on open

  • Thread starter Thread starter Brenner
  • Start date Start date
B

Brenner

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
 
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
 
Thank you, Sir!

Is it possible to put a drop down list box in the input message?

Thanks,
John
 
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.
 
Thank you, Gary's Student. I'll do that.

John

Gary''s Student said:
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.
Click to expand...
 
Back
Top