LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 441
Default Show what options are in custom function?

I am using Office 2003 on Windows XP.

Suppose you have a custom public function which requires certain arguments.
Suppose further that one of those arguments could be one of three choices.

When you call the function and open the parentheses you see the listed
arguments. Is it also possible to show the three possible choices for the one
argument?

Is so, could someone please illustrate how to do this? See example function
below:

Public Function CalculateValue(argItem1, argItem2, argType) as Long
If argType = "Normal" then ...
If argType = "Modified" then ...
If argType = "None" then ...
End Function

When I'm entering a call to the function as in: Call
CalculateValue(lngValue1, lngValue2, ...), when I get to the point where I
need to enter the "argType" I want to see what my options are (i.e. Normal,
Modified, or None). Kind of like auto-sensing.

Can this be done? If so, how? Thanks much in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
In the Options window how to create new custom lists Nguyen Duc Diep Excel Discussion (Misc queries) 2 August 24th 06 05:13 PM
Custom Filtering more than 2 options Visual Calendar Dilemma Excel Discussion (Misc queries) 1 June 13th 06 02:51 AM
Tools Options Custom Lists starguy Excel Discussion (Misc queries) 3 April 21st 06 06:13 AM
options custom list davemorrison Excel Worksheet Functions 1 February 4th 06 12:23 PM
Autofilters-Remove (Top 10...) and (Custom) options from the drop- Jen in SoCA Excel Worksheet Functions 1 August 27th 05 03:04 AM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"