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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Wich Cells To Include In Print 2
Can't Edit Worksheet Comments 1
Excel Import Comments 3
Prefilled Outlook Yes Voting Button response 0
Extract Cell Comments and Paste as text in a cell 3
Question regarding comments 2
Add comment in protected worksheet 3
Word to Excel: Export comments with text and line number 0

Back
Top