Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check box help
My program currently uses a forms-type check box (a shape as opposed to an
OLE object, I think). I use this type because it was more convenient to use the OnAction property when defining teh check box and I couldn't figure out how to set the OnAction for an OLE object. The trouble is the default mouse pointer for the check box is a hand, rather than the pointer. Can anyone help me to either: 1) define an OnAction property for the one type of check box or 2) change the mouse pointer property for the other. Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200607/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check box help
With OLEObjects, there are associated events. If you go to design mode, the
blue-green triangle on the control toolbox, you can then double-click the object, and that will take you to the sheet code window, with a click event for that object outlined for you. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "excel_stuck via OfficeKB.com" <u23938@uwe wrote in message news:636dd6b6189c7@uwe... My program currently uses a forms-type check box (a shape as opposed to an OLE object, I think). I use this type because it was more convenient to use the OnAction property when defining teh check box and I couldn't figure out how to set the OnAction for an OLE object. The trouble is the default mouse pointer for the check box is a hand, rather than the pointer. Can anyone help me to either: 1) define an OnAction property for the one type of check box or 2) change the mouse pointer property for the other. Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200607/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
check box help
Thanks Bob, but I probably need to be clearer. I currently create the check
box (actually many of them) in a macro. At creation time, I define the OnAction ( .OnAction = "blah" ). This allows me a generic routine for all checkboxes. Then, in the code, I figure out which checkbox (type) has been clicked to decide the appropriate action. With your suggestion, unless I am missing something (which is probably the case!) I am assigning a specific click action for a specific checkbox. I was hoping to use a global click action for all checkboxes, and use the OnAction method for defining it (for the OLEObjects-type checkbox). Alternatively (an simpler for me, regarding lots of code changes), I was hoping to define the mousepointer property for a shapes-type checkbox. I hope that is clearer... Bob Phillips wrote: With OLEObjects, there are associated events. If you go to design mode, the blue-green triangle on the control toolbox, you can then double-click the object, and that will take you to the sheet code window, with a click event for that object outlined for you. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) My program currently uses a forms-type check box (a shape as opposed to an OLE object, I think). I use this type because it was more convenient to use [quoted text clipped - 9 lines] Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200607/1 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200607/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a check form, and then have info go to a check register | Excel Worksheet Functions | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) |