I had some help earlier; where I'm trying to have a macro run once its selected from a combo box - and this code works well:
![]()
Private Sub ComboBox1_Change() Select Case ComboBox1.Value Case 1 Call Macro1 Case 2 Call Macro2 Case 3 Call Macro3 Case 4 Call Macro4 End Select End Sub
What I'm getting hung up on is the macros only run if its numbers populating the combo box, say if my linked cells read 1-7 that would work but Sunday-Saturday does nothing. Is there something in the properties menu or in the coding that can read numbers but not characters? Thank you
Bookmarks