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
|