Comments For Buttons

  • Thread starter Thread starter mathew
  • Start date Start date
M

mathew

Good Evening All,

Is it possible to asign a comment to a command_buttonX, so
that prior to clicking it, the user is informed of the
parameters required, eg "Select any cell in cloumn A"
Any thoughts?

Cheers
Mathew
 
Hi Mathew,

Maybe it were interesting if you criticize the selection at start of the
macro, for example:

Private Sub CommandButton1_Click()
If Intersect(Selection(), Range("A:A")) Is Nothing Then
MsgBox "Please, select any cell in cloumn A and try again"
Exit Sub
End If
'Start your code from here
End Sub

HTH
 
Back
Top