Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 113
Default Definitions for Activex control properties?

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jaf jaf is offline
external usenet poster
 
Posts: 300
Default Definitions for Activex control properties?

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 113
Default Definitions for Activex control properties?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Properties on Excel Worksheet and definitions Don Excel Discussion (Misc queries) 1 January 11th 08 11:38 AM
ActiveX Control Compatibility Racer49 Excel Discussion (Misc queries) 4 May 26th 07 05:32 AM
How do I change activex control properties from a macro Billums Excel Discussion (Misc queries) 2 January 19th 06 01:21 PM
How to add an ActiveX control in Excel? Dicaprio Excel Worksheet Functions 0 November 4th 05 03:30 AM
Tab to an ActiveX control? Karin Excel Discussion (Misc queries) 0 July 6th 05 05:08 AM


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"