Forum Discussion
sf49ers19238597
Dec 14, 2020Iron Contributor
I have a friend that need help with vab code
need help with part of vba code If Me.cmbWeek.ListIndex > -1 Then
Set Ws = Worksheets(Me.cmbWeek.Value)
Else: MsgBox "INCORRECT INPUT." & vbNewLine & "Use Dropdown For Listed We...
HansVogelaar
Dec 14, 2020MVP
The code refers to a combo box named cmbWeek, but there is no combo box on the userform.
Delete the part of the code shown in your post (from If to End If)
sf49ers19238597
Dec 14, 2020Iron Contributor
delete whole selection I mean an do not put anything or for new code?
- HansVogelaarDec 14, 2020MVP
Yes, simply select that part and press Delete. You don't have to replace it with anything.
- sf49ers19238597Dec 15, 2020Iron Contributor
- HansVogelaarDec 15, 2020MVP
Which line causes that error?