Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Wizard
I am trying to simulate the function wizard thru a macro
which will show the function wizard for a perticuler function. So far I have ActiveCell.FunctionWizard which shows the screen to select the function. How do I make the wizard to show directly next screen with arguments for a perticuler function (say SUM)? Regards, Madiya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Wizard
Possibly
ActiveCell.Formula = "=Sum(1)" ActiveCell.FunctionWizard -- Regards, Tom Ogilvy "Madiya" wrote in message ... I am trying to simulate the function wizard thru a macro which will show the function wizard for a perticuler function. So far I have ActiveCell.FunctionWizard which shows the screen to select the function. How do I make the wizard to show directly next screen with arguments for a perticuler function (say SUM)? Regards, Madiya |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Wizard
Tom,
Thanks for your help. It still shows the initial screen to choose a function. I want 1 step further. Excel should show the screen which shows the arguments for the functions selected. However if I rerun the same macro, it shows the right screen. Any other suggession? Regards, Madiya "Tom Ogilvy" wrote in message ... Possibly ActiveCell.Formula = "=Sum(1)" ActiveCell.FunctionWizard -- Regards, Tom Ogilvy "Madiya" wrote in message ... I am trying to simulate the function wizard thru a macro which will show the function wizard for a perticuler function. So far I have ActiveCell.FunctionWizard which shows the screen to select the function. How do I make the wizard to show directly next screen with arguments for a perticuler function (say SUM)? Regards, Madiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function wizard on office 2003 | Excel Worksheet Functions | |||
where is the function wizard in excell?? | Excel Worksheet Functions | |||
Function Wizard | Excel Discussion (Misc queries) | |||
Check if within Function Wizard | Excel Programming | |||
function wizard access violations | Excel Programming |