how do I find out property values for each control object?

[Bob Allen]

How do I find out what the various values in the Property box actually do,
have happen, etc. for ALL of the various property elements? For example I am
currently using the RowSource property in VBA for Excel - but I would like to
know what the other property do, control, format, etc.

There must be lists of these elements and the various values that may be
placed in the elements - and the ramifications for the various values.

By an element I mean - things like RowSource, Name, Font, etc.

 

[Dave Peterson]

There's lots of information in VBA's help.

And don't be afraid to experiment in a test workbook.

 

[Bob Allen]

Hi Dave,

Let's take a Combo box for example - I've tried to follow the Excel 2007
Help for VBA and don't know how to phrase the question in the VBA help area
to get a listing of the collective list of elements of the properties for the
Combo Box. Isn't there a list somewhere of the various elements? - and the
various values?

ALSO - important - I have now asked 2 different question through this system
and have received two separate emails back. HOWEVER - the links in both
emails (Read & Rate) and (Continue to Receive Notices) ONLY bring up blank
pages!

I only got to this page to read your response by going to the Properties of
the (Read & Rate link) cutting the URL Address, and then pasting the Address
in to a Browser. There should be an easier way.

 

[Dave Peterson]

Go into the VBE
Search for "Combobox Control"
Click on the "ComboBox Control (Forms)" link.

At the top of that page, you'll see a line with a bunch of links:
See Also Example Properties Methods Events Specifics

(I'm using xl2003 for this. And Specifics is disabled.)

Click on the properties and you'll see a dropdown list appear.

Choose the one you're interested in.

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's books are very good to start.

See if you can find them in your local bookstore/internet site and you can
choose what one you like best.

================
I use a newsreader to access the newsgroups directly.

Saved from a previous post:

If you're able (not behind a firewall at work???), you may want to connect
directly to the MS newsservers.

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsoft.public.word.docmanagement
news://msnews.microsoft.com/microsoft.public.word.word97vba
news://msnews.microsoft.com/microsoft.public.word.newusers
news://msnews.microsoft.com/microsoft.public.word.pagelayout
news://msnews.microsoft.com/microsoft.public.word.vba.addins
news://msnews.microsoft.com/microsoft.public.word.vba.beginners
news://msnews.microsoft.com/microsoft.public.word.vba.customization
news://msnews.microsoft.com/microsoft.public.word.vba.general
news://msnews.microsoft.com/microsoft.public.word.vba.userforms
news://msnews.microsoft.com/microsoft.public.word.word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm



The easier way to read