LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Set OptionBox value via VBA

Chip,

Thanks for the clarifications.
The really frustrating thing is that 1) the ID #s for the controls don't
seem to be exposed anywhere in the API (or at least not in the Excel GUI),
and 2) the behavior of the controls with/without being linked to a worksheet
cell is not clearly documented anywhere that I could find.
Of course, the cute excel xlON/xlOFF constants and their nifty,
not-exactly-intuitive values doesn't exactly help avoid any confusion any
either (it wouldn't be so bad if those constants were enums for the .value
property, but apparently that was too obviously self-documenting a situation
to hope for).

Do you know if anybody's made anything like a comprehensive
document/whitepaper/website/guide to "The Proper care and feeding of Excel
and ActiveX controls in both Userforms and on Worksheets."?
I could also easily imagine the need for a similar set of guides/documents
for the multitude of SHAPE objects (_not_ counting the controls). One
specific question I have is this: where is there a document that lists all
the various valid Adjustment points for the various autoshapes? ....or is
there no such animal anywhere?

 
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
How to set Optionbox value from code? Mark Burns Excel Programming 2 March 5th 09 04:46 PM
Code for OptionBox Noepie Excel Programming 2 December 12th 08 10:30 AM
Excel Checkboxs, Optionbox Brandon Excel Discussion (Misc queries) 1 January 19th 07 08:25 PM
optionbox checkbox flow23 Excel Discussion (Misc queries) 3 November 24th 05 01:00 PM
OptionBox error checking Patrick Simonds Excel Programming 1 September 29th 05 08:39 AM


All times are GMT +1. The time now is 09:14 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"