Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Each ActiveX control inserted on a worksheet has a list of properties that
can be viewed in the 'Properties' window. Where do we go to get help on what each of these properties can do or control? Some properties are self-evident, but others are not so self-explanatory. For example, in the case of a Check Box control, there are properties such as Accelerator, Autoload, GroupName, and Placement, whose purpose or function is not so apparent. Thank you for any help finding a resource for this issue. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
For a worksheet control: Click on the control (check box) so the resize border is visible. Right click on the control and select properties. The properties window will open. Click the property you want to learn about and then press F1. The help window should open and display the property usage. For a VBA userform control you only need to select the control and press F1. John "Blue Max" wrote in message ... Each ActiveX control inserted on a worksheet has a list of properties that can be viewed in the 'Properties' window. Where do we go to get help on what each of these properties can do or control? Some properties are self-evident, but others are not so self-explanatory. For example, in the case of a Check Box control, there are properties such as Accelerator, Autoload, GroupName, and Placement, whose purpose or function is not so apparent. Thank you for any help finding a resource for this issue. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you, John, extremely helpful! However, we did note that many of the
properties do not bring up any individualized help (such as the AutoLoad, Enabled, LinedCell, Locked, Placment and othe properties). Thanks again for a great hint! ***************************** "jaf" wrote in message ... Hi, For a worksheet control: Click on the control (check box) so the resize border is visible. Right click on the control and select properties. The properties window will open. Click the property you want to learn about and then press F1. The help window should open and display the property usage. For a VBA userform control you only need to select the control and press F1. John "Blue Max" wrote in message ... Each ActiveX control inserted on a worksheet has a list of properties that can be viewed in the 'Properties' window. Where do we go to get help on what each of these properties can do or control? Some properties are self-evident, but others are not so self-explanatory. For example, in the case of a Check Box control, there are properties such as Accelerator, Autoload, GroupName, and Placement, whose purpose or function is not so apparent. Thank you for any help finding a resource for this issue. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Properties on Excel Worksheet and definitions | Excel Discussion (Misc queries) | |||
ActiveX Control Compatibility | Excel Discussion (Misc queries) | |||
How do I change activex control properties from a macro | Excel Discussion (Misc queries) | |||
How to add an ActiveX control in Excel? | Excel Worksheet Functions | |||
Tab to an ActiveX control? | Excel Discussion (Misc queries) |