Set a size for user entry section of InputBox ?

[JoAnn]

Is there any way to specify a size for the user input section of VBA's
InputBox(preferably something that would grow vertically with content as
needed but retain its width)?

Right now it, it's a single line & I'd like it to be a box (if doable) so
folks can easily review/edit their information before pressing OK.

Thanks!

 

[Jay Freedman]

Is there any way to specify a size for the user input section of VBA's
InputBox(preferably something that would grow vertically with content as
needed but retain its width)?

Right now it, it's a single line & I'd like it to be a box (if doable) so
folks can easily review/edit their information before pressing OK.

Thanks!

You can't make any changes at all to a real InputBox. However, you can
make a UserForm that works like an InputBox -- start at
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm.

In fact, you can make the UserForm a lot smarter than an InputBox,
including validation of the user's entry, multiple entries on one
form, list boxes whose choices depend on the user's input in other
controls, etc.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[JoAnn]

Thanks. I'll give it a try.
--
JoAnn

You can't make any changes at all to a real InputBox. However, you can
make a UserForm that works like an InputBox -- start at
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm.

In fact, you can make the UserForm a lot smarter than an InputBox,
including validation of the user's entry, multiple entries on one
form, list boxes whose choices depend on the user's input in other
controls, etc.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.