Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a list of VB addressable fields for Excel ?
See the subject really, i'm after a list of all VB addressable fields
for Excel/97 is such a thing exists. Regards Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a list of VB addressable fields for Excel ?
or check the object browser
-- HTH RP (remove nothere from the email address if mailing direct) "Dave Patrick" wrote in message ... Do you mean constants? If so here's a start. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Fred" wrote: | See the subject really, i'm after a list of all VB addressable fields | for Excel/97 is such a thing exists. | | Regards | Fred | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a list of VB addressable fields for Excel ?
What is an "addressable field"?
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Fred" wrote in message oups.com... See the subject really, i'm after a list of all VB addressable fields for Excel/97 is such a thing exists. Regards Fred |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a list of VB addressable fields for Excel ?
Apologies, I know what I mean, but expecting others to understand, I
suppose, is a little unreasonable. I meant items such as : ActiveSheet.PageSetup.PrintTitleRows ActiveSheet.PageSetup.PrintTitleColumns ActiveWindow.ScrollRow ActiveSheet.Name cell.Interior.ColorIndex cell.Font.ColorIndex cell.Interior.Pattern cell.Interior.PatternColorIndex Cheers Fred |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a list of VB addressable fields for Excel ?
go to Chip Pearson's downloads page:
http://www.cpearson.com/excel/download.htm and look for TLIUtils Provides VBA procedures for working with type libraries, via the TypeLib Information object. Documentation of the available procedures is available in the VBA code modules. -- Regards, Tom Ogilvy "Fred" wrote in message oups.com... Apologies, I know what I mean, but expecting others to understand, I suppose, is a little unreasonable. I meant items such as : ActiveSheet.PageSetup.PrintTitleRows ActiveSheet.PageSetup.PrintTitleColumns ActiveWindow.ScrollRow ActiveSheet.Name cell.Interior.ColorIndex cell.Font.ColorIndex cell.Interior.Pattern cell.Interior.PatternColorIndex Cheers Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up multiple fields in a list box? | Excel Discussion (Misc queries) | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
excel 2007_need to add spacing between fields for mailing list | New Users to Excel | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Can I sort a list with more than three fields? | Excel Discussion (Misc queries) |