Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Directories
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 ? -- wardides ------------------------------------------------------------------------ wardides's Profile: http://www.excelforum.com/member.php...o&userid=15022 View this thread: http://www.excelforum.com/showthread...hreadid=266858 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Directories
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.) wardides wrote: 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 ? -- wardides ------------------------------------------------------------------------ wardides's Profile: http://www.excelforum.com/member.php...o&userid=15022 View this thread: http://www.excelforum.com/showthread...hreadid=266858 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating directories | Excel Discussion (Misc queries) | |||
Creating Directories | Excel Programming | |||
Creating Directories | Excel Programming | |||
Creating a list of directories | Excel Programming | |||
Creating Directories | Excel Programming |