Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find out property values for each control object?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find out property values for each control object?
There's lots of information in VBA's help.
And don't be afraid to experiment in a test workbook. Bob Allen wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find out property values for each control object?
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. "Bob Allen" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find out property values for each control object?
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/microsof...ic.excel.setup news://msnews.microsoft.com/microsoft.public.excel.misc news://msnews.microsoft.com/microsof...heet.functions news://msnews.microsoft.com/microsof...excel.newusers news://msnews.microsoft.com/microsof...el.programming (and a few more for MSWord) news://msnews.microsoft.com/microsof....docmanagement news://msnews.microsoft.com/microsof...word.word97vba news://msnews.microsoft.com/microsof....word.newusers news://msnews.microsoft.com/microsof...ord.pagelayout news://msnews.microsoft.com/microsof...ord.vba.addins news://msnews.microsoft.com/microsof....vba.beginners news://msnews.microsoft.com/microsof....customization news://msnews.microsoft.com/microsof...rd.vba.general news://msnews.microsoft.com/microsof....vba.userforms news://msnews.microsoft.com/microsof....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_tut...e_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_gr...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 Bob Allen wrote: 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. "Bob Allen" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Object property/method problem | Excel Discussion (Misc queries) | |||
I can't find the command button control object in Excel 2007 | Excel Discussion (Misc queries) | |||
Lookin property of the FileSearch object | New Users to Excel | |||
List of property names and values for a given object. | Excel Worksheet Functions |