VBA FromList Choose Problem

For some odd reason I can get this code to work in the attached workbook, but I cannot get it to work in any other ones without the error "Compile error: Argument not optional". I don't have option explicit on.

Sub list_ojb()

Dim uiotherchoices
uiotherchoices = Choose.FromList(Array("Game", "Communications", "Medical"), "Choose one")
End Sub

Why do I get that error and how do I fix it? Thanks for your help.

Not sure I understand what you are trying to achieve, but if you want to place the chosen value on in Sheet1 B2 in the activeworkbook, then change.

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

I figured it out...I'm going to have to build an user form.