Adding variable input dialog windows to worksheet function

J

jwirt212

I would like to add the dialog feature for entering variables in an
Excel built-in function that pops up when one enters the function in
the worksheet to a user defined worksheet function. Can this be done?

I want to be able to enter multirow ranges as a variable in this user
defined worksheet function.

Can someone tell me what the dialog window is called and how I can find
information about how to code it into my user defined function.

Thanks.

John Wirt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top