Named Argument not found

When I run this code, I get "Named Argument Not Found" with "Type" highlighted on the debugging screen. What's wrong? With Number DIM as Integer will this code prevent people from closing the input box without entering anything? Thanks

Please Login or Register  to view this content.

There are two kinds of input boxes immediately available in the Excel VBIDE, so you have to be a little careful.

VBA.InputBox
Application.InputBox

The VBA Inputbox does not have a Type parameter - and that is the InputBox you are calling - so you get an error. You want the Application.InputBox.

Please Login or Register  to view this content.

Well, that helps. LOL Thanks Colin.

But it's rather odd to use an inputbox if you also use userforms.

You can use 2 frames in a userform. At the start the second one is hidden.
In the first one the user can enter the number of teams (preferably using a spinbutton (min1 max 6))
After exiting the spinbutten the second frame can be shown with as many textboxes as indicated by the spinbutton.

Thanks snb. I will play with that until I am comfortable with it.