Thread: VB code help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default VB code help

I have a combobox that displays a list of 'options' to the user.
I want a certain macro to run or userform to be displayed for each 'option'
that is chosen.
I have this code, but I can't get it to work

Sub DropDown49_Change()
Select Case DropDown49.Value

Case "Add new Job"
frmNewJob.show
Case "Edit report"
frmEditJobref.show
Case "View old report"
frmGetJob.show
Case "View Adhoc Log"
Sheets("adhoc").Select
Case "Add Shift Report"
Sheets("sheet2").Select
frmReport.show

End Select

any help in fixing it and where to place the code would be appreciated