Mackeral
Board Regular
- Joined
- Mar 7, 2015
- Messages
- 249
- Office Version
- 365
- Platform
- Windows
This an example of an Enum definition
I will define a function I will call "Test
When I type in
all I see is
and no drop-down list appears where I use to see a Dropdown list where I could select either "X1" and "X2".
If you use a VBA non-Enum term like "Boolean" as in "Call Test(Arg as Boolean)", you see
a Dropdown list showing"True" and "False".
Any idea what I have done wrong, or has something changed in VBA?
VBA Code:
Enum XXX
X1 = 1
X2 = 2
End Enum
I will define a function I will call "Test
VBA Code:
Function Test(Arg as XXX)
' Some Code
End Function
When I type in
VBA Code:
Call Test(
VBA Code:
Test:Display as XXX)
If you use a VBA non-Enum term like "Boolean" as in "Call Test(Arg as Boolean)", you see
a Dropdown list showing"True" and "False".
Any idea what I have done wrong, or has something changed in VBA?