PC Review


Reply
Thread Tools Rate Thread

Auto start Function Wizard

 
 
=?Utf-8?B?U3RldmUgRA==?=
Guest
Posts: n/a
 
      25th Jul 2007
Good Morning,
I have created a user defined function and I have a toolbar button that
will insert the function into a cell. I would like for the toolbar button to
also open the function wizard so that the user can easily populate the range
and criteria for the function. Is there a way to do this?
--
Thank You,
Steve
 
Reply With Quote
 
 
 
 
=?Utf-8?B?Sk5X?=
Guest
Posts: n/a
 
      25th Jul 2007
If you already select the cell in your code then just add the following line:

Application.Dialogs(xlDialogFunctionWizard).Show

If you don't select the cell already you'll need to do that so that the
function wizard has a formula to reference.

--
JNW


"Steve D" wrote:

> Good Morning,
> I have created a user defined function and I have a toolbar button that
> will insert the function into a cell. I would like for the toolbar button to
> also open the function wizard so that the user can easily populate the range
> and criteria for the function. Is there a way to do this?
> --
> Thank You,
> Steve

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sub Macro vrs Function Macro Auto Start =?Utf-8?B?UGF0?= Microsoft Excel Misc 7 6th Jun 2007 09:53 PM
Auto-start service doesn't auto-start Margaret MacDonald Microsoft Windows 2000 4 6th Feb 2006 06:00 PM
IE won't start from Start; will start from Control Panel, Auto Updates Ed Katzman Windows XP Internet Explorer 1 30th Dec 2005 07:16 PM
Re: XP Home - Add Printer Wizard won't start - HP 6122 deskjet won't auto install Robert Orleth [MSFT] Windows XP Print / Fax 0 2nd Jan 2004 08:48 PM
CD-ROM/DVD AUTO START FUNCTION LENORA WOODS Windows XP Performance 1 16th Jul 2003 08:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:27 AM.