I am trying to make sure that a listbox value is selected before a macro will run, but cannot get it to work. I am trying the following code but am not having any luck.
Code:
Private Sub CommandButton2_Click()
If IsNull(ListBox3.value) = True Then
MsgBox "Please select the sheet that you want the information to go to"
Exit Sub
Else
Call movea
End If
End Sub