VBA syntax question


Posted by Darin on January 29, 2002 7:50 AM

When I try to do a VBA program, I type in

Input "Enter next number: ", x

and the computer tells me there is a syntax error, and says something about expecting #.

Why is there a problem with my Input line?

Posted by JohnG on January 29, 2002 8:01 AM

was this what yo were afer?
Sub INbox()
'InputBox(Message, Title, Default)
InputBox "Enter next number: ", x
End Sub

Input on its own is for reading from files.



Posted by Darin on January 29, 2002 9:44 AM

Yes! Thank you very much for your help, John G.