Comments For Buttons

[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

 

[Orlando Magalhães Filho]

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