Excel VBA Doesn't Seem to Recognize SelectionBoxSingle()

[bonzo]

When I try to use the SelectionBoxSingle() function in Excel VBA, it abends into the debugger with "Compile error: Sub or Function not defined". Do I need some kind of Excel plugin to have access to this function? What am I missing? I'm using Office 365 on a Windows 10 Enterprise.

 

[Michael M]

Can you post the code you are using it in ??

 

[bonzo]

I did an Internet search & copied sample code from one of the search results pages. It's very basic at this point. With the "Compile error: Sub or Function not defined" error, there doesn't appear to be any issues like undefined variables or syntax errors.

Dim varArrayList As Variant
Dim strSelected As String
varArrayList = Array("value1", "value2", "value3")
strSelected = SelectionBoxSingle(List:=varArrayList)
If Len(strSelected) > 0 Then
Debug.Print strSelected
End If

 

[Michael M]

Have you set a reference to Microsoft Forms 2.0 Object Library (menu: Tools > References). ??
Have you created the actual SelectionBox object ??

 

[bonzo]

I haven't done either of those things -- because I didn't see anything on the search results page that said any of that was necessary. It just looked like another available pre-defined function. I looked at another search results page that seems to have provided more details, including info about some things to download as well as the reference library. I need to check this out further & see how far I can get. Thanks for the pointers!

 

[RoryA]

It's not native VBA. I suspect you are referring to this: SelectionBox vba dialog