msgbox with text input

[swarv]

All,

I want a msgbox to appear (which is fine) but i want the use to be able to enter a word and then that word to be used as a variable.

e.g. dayvalue = msgbox ("Enter a day", vbok)

then when the user clicks on ok it will return the value that the user entered so i can use it later on in the code. Is this possible?

thanks

Martin

 

[rainman89]

Sure. Make your own form that looks and appears to be a messagebox.

 

[KenHigg]

I think you need to use the InputBox function.

 

[swarv]

excellent inputbox works wonders. Thanks a lot.

 

[KenHigg]

Glad to help...

fyi - InputBox has no validation abilities and should be used sparingly