Combo box as an argument of an UDF

Guido Meng Guido Meng is offline

New Member

Join Date: Sep 2008

Posts: 3

26th Sep 2008

Hello

I've just recently learned how to use User Defined Functions (UDFS) but I've been unable to make one or more of the arguments of the UDFS to have a drop list with a limited number of options, for example TRUE or FALSE, any given day of the week, etc. Can someone please tell me if there is a way for doing this, using VBA or maybe inserting some sort of ActiveX control (Combo or List Box) into a UDF argument so that the end user of the function has a limited number of options to choose.

Thanks...

« How change cell to another character, add comma, & continue next c | Time format »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Editable combo box \| Argument out of range exception	=?Utf-8?B?Tmljaw==?=	Microsoft Dot NET	0	7th Jun 2006 10:38 AM
Function (array argument, range argument, string argument) vba	Witek	Microsoft Excel Programming	3	24th Apr 2005 03:12 PM
Pass selection from combo box as argument for query	Frustrated	Microsoft Access Form Coding	1	8th Aug 2004 08:16 PM
Link Combo Box to Autofilter argument	JohnWRS	Microsoft Excel Programming	0	21st Apr 2004 06:12 PM
How to overcome the limitation: Cannot pass 'argument' as ref or out, because ' argument ' is a marshal-by-reference class	Mountain Bikn' Guy	Microsoft C# .NET	2	15th Nov 2003 07:45 PM