Prompt for input

[Simon Harris]

Hi All,

Is there a VBA equivilant to javascript prompt? I want to pop up a box (From
a module) asking the user for a date. I know this will return a string, but
I plan to specifiy the input and then validate it.

All I can find is MsgBox, which seems to be the same as a JavaScript alert.

Any help will be much appreciated.

Regards,
Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

 

[SusanV]

The function you're looking for is InputBox

 

[Simon Harris]

Great, thanks Susan.

The function you're looking for is InputBox