Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
properties of excel button/checkbox
Hi all,
Using forms bar, I created a button & a check box for each row. I wish for the the button/check box to perform a specific task via macro on the row it is located on. my questions a 1) How do i know what row is accosiated with a specific button/check box? 2) The check box run the assigned macro when it's marked and also when it is unmarked. How may I query for the status? any help would be appreciated. tnx, valiky |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
properties of excel button/checkbox
Option explicit
sub test1 dim BTN as button set BTN = activesheet.buttons(application.caller) msgbox btn.topleftcell.address '.row, .column end sub sub test2 dim CBX as checkbox set CBX = activesheet.checkboxes(application.caller) if cbx.value = xlon then 'checked else 'not checked, it's xlOff end if msgbox cbx.topleftcell.address '.row, .column end sub yaniv wrote: Hi all, Using forms bar, I created a button & a check box for each row. I wish for the the button/check box to perform a specific task via macro on the row it is located on. my questions a 1) How do i know what row is accosiated with a specific button/check box? 2) The check box run the assigned macro when it's marked and also when it is unmarked. How may I query for the status? any help would be appreciated. tnx, valiky -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Properties | Excel Discussion (Misc queries) | |||
button properties | Excel Discussion (Misc queries) | |||
command button properties | Excel Worksheet Functions | |||
Spinner Button properties | Excel Discussion (Misc queries) | |||
Command Button Properties | Excel Programming |