MsgBox to read a value

[mtheriault2000]

Hello

I know that i could use MsgBox to read a yes no answer. Is it possible to use it to read and integer number?

I'm displaying a list of option like
ShowMessage =
1: abcd & chr(10)
2: efgh & chr(10)
3: qwer

Rep = msgbox(ShowMessage, ???)

How could i read the answer from the user?

Martin

 

[repairman615]

Hello,

If you would like Multiple Choice, why not use an InputBox?

Using a MsgBox would entail many Yes/No type questions to arrive at an answer.


<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> a()<br><SPAN style="color:#00007F">Dim</SPAN> showmessage <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">String</SPAN><br><br>showmessage = "Choose 1, 2 or 3" & Chr(10) & "1: abcd" & Chr(10) & "2: efgh" & Chr(10) & "3: qwer"<br><br><SPAN style="color:#00007F">Select</SPAN> <SPAN style="color:#00007F">Case</SPAN> InputBox(showmessage)<br>    <SPAN style="color:#00007F">Case</SPAN> 1<br>        MsgBox 1<br>    <SPAN style="color:#00007F">Case</SPAN> 2<br>        MsgBox 2<br>    <SPAN style="color:#00007F">Case</SPAN> 3<br>        MsgBox 3<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Select</SPAN><br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[mtheriault2000]

AH!

Never used InputBox....
Thank you so much

 

[repairman615]

Your Welcome,

Glad to Help!