ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Example of input or msg box requesting TWO pieces of info? (https://www.excelbanter.com/excel-programming/357099-example-input-msg-box-requesting-two-pieces-info.html)

StargateFan[_3_]

Example of input or msg box requesting TWO pieces of info?
 
I've used boxes that only deal with one item request. Is there a way
to request to user input items? If so, can anyone point me to an
example on the net?

Thanks.


[email protected]

Example of input or msg box requesting TWO pieces of info?
 
You could create a userform with two textboxes on it.

Or bring up two inputboxes, one after the other;

usrIn1 = input("Type your first response...")
usrIn2 = input("Type your second response...")
msgbox "you typed; " & chr(13) & "1: " & usrIn1 & chr(13) & "2: " &
usrIn2


Bob Phillips[_6_]

Example of input or msg box requesting TWO pieces of info?
 
No, you should build a custom userform for that.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"StargateFan" wrote in message
...
I've used boxes that only deal with one item request. Is there a way
to request to user input items? If so, can anyone point me to an
example on the net?

Thanks.





All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com