Prev: Windows update
Next: Changes to working code
From: Subodh on 14 May 2010 20:52
I have a function named mysub and with parameters that has to be
supplied to the function.
I want that when the cell where the function is to be inserted, the
user can type the arguments of the
function sub after they have run the sub. Lets say, that after the sub
is run, they get =mysub(..) with the
cursor in between the parenthesis and so that they can move with
typing of the arguments/parameter of the
function.
So, in summary, the advantage is that, the user should not type =mysub
through the keyboard
or they donot even need to remember that provied that there are large
number of such functions.
Thanks for your response.
From: Per Jessen on 15 May 2010 07:28
I am not sure if it can be done. Anyway I would use an inputbox in the macro
to prompt for the parameter, or if there are several paramteres maybe use an
userform. Then insert the complete formula into the cell.

Regards,
Per

"Subodh" <getsubodh(a)gmail.com> skrev i meddelelsen
news:9df5971c-6a8f-4ea2-bb50-541c996204df(a)v29g2000prb.googlegroups.com...
> I have a function named mysub and with parameters that has to be
> supplied to the function.
> I want that when the cell where the function is to be inserted, the
> user can type the arguments of the
> function sub after they have run the sub. Lets say, that after the sub
> is run, they get =mysub(..) with the
> cursor in between the parenthesis and so that they can move with
> typing of the arguments/parameter of the
> function.
> So, in summary, the advantage is that, the user should not type =mysub
> through the keyboard
> or they donot even need to remember that provied that there are large
> number of such functions.
> Thanks for your response.

 | 
Pages: 1
Prev: Windows update
Next: Changes to working code