Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expose Function Fieldnames to VBA
When I type =SUM and then press Ctrl-Shift-A excel shows me the field
names in the formulabar that I can then copy and use. Is there a way to retrieve those fieldnames through VBA directly? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expose Function Fieldnames to VBA
What are wanting to use those for? Those field names are just
variables that it needs. If go into your VBA code and type "worksheetfunction.Sum( ", then the intellisense pops up and you'll see all the arguments/variables that the Sum() function needs. Will that do? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expose Function Fieldnames to VBA
What are wanting to use those for? *
I need the fieldnames in runtime because I created my own function dialog. The default excel function dialog is fine for most purposes and I would like very much to use that as the basis for an extended dialog, but I need more information to evaluate and break down complex formulas. Also the Evaluate Tool in excel does not give me the information I want. Regards, André |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expose Function Fieldnames to VBA
Maybe you could try making your own function in VBA code? Then you
would have access to those variables that are used in your own function. Can you post some code of what you have so far maybe? I guess I'm still not understanding exactly. sorry Those field names are nothing but values ASSIGNED to them... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expose formulas | Excel Programming | |||
How to Expose SeriesCollection? | Excel Programming | |||
Match dBase with Fieldnames | Excel Worksheet Functions | |||
Expose macros with add-in | Excel Programming | |||
ADO Weirdness: Changes dots to #'s in FieldNames | Excel Programming |