- Joined
- Sep 25, 2008
- Messages
- 3
- Reaction score
- 0
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...
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...