Creating Directories

  • Thread starter Thread starter wardides
  • Start date Start date
W

wardides

I need to also work out which button has been pressed.

set cell = Activesheet.Buttons(1).TopLeftCell

will work once I know what button has been preseed. Is there code that
will give me the ID of the button that has been pressed ?
 
dim myBTN as button
set myBTN = activesheet.buttons(application.caller)
msgbox application.caller & vblf & mybtn.topleftcell.address _
& mybtn.caption

(Not sure what the ID is.)
 
You must log in or register to reply here.

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

Multiple questions 3
Unhide sheet 2
Setting .OnAction of a command button terminates my macro..... 4
Add button to worksheet cell 3
Command Button Question 8
Delay when userform resizes?? 3
Continual addition to Cell 1
Macro correction needed 2

Back
Top