Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble w/ creating a VBA function that uses an enum in it's parameters
Greetings,
I have an enum that I use as a variable in a function. If I call on the function from w/in the VBA IDE, the enum values are displayed, but not when I call on the function from w/in Excel. I have tried all sorts of things, but I am at my wit's end. Here is the code... Public Enum To_Unit eMinute = 1 eHour = 2 eDay = 3 eWeek = 4 eMonth = 5 End Enum Public Function ChangeUnit(Target As Range, ToUnit As To_Unit) As Long Thanks in advance, Jacob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble w/ creating a VBA function that uses an enum in it's parameters
Hi Jacob,
If you mean that Excel doesn't display the text values of your enumeration members when you use your function as a worksheet function, it's because Excel doesn't support this feature for worksheet functions. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm wrote in message oups.com... Greetings, I have an enum that I use as a variable in a function. If I call on the function from w/in the VBA IDE, the enum values are displayed, but not when I call on the function from w/in Excel. I have tried all sorts of things, but I am at my wit's end. Here is the code... Public Enum To_Unit eMinute = 1 eHour = 2 eDay = 3 eWeek = 4 eMonth = 5 End Enum Public Function ChangeUnit(Target As Range, ToUnit As To_Unit) As Long Thanks in advance, Jacob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble w/ creating a VBA function that uses an enum in it's parameters
OK, that would answer it. Thanks.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble creating table | Excel Discussion (Misc queries) | |||
having trouble creating chart to show monthly totals | Charts and Charting in Excel | |||
Creating a local and hidden name; Parameters | Excel Programming | |||
Enum | Excel Programming | |||
Enum in Excel 97 | Excel Programming |