How can I generate a POP-UP window.

[saraf]

Hi All,

How can I generate POP-UP window with a msg " Choose the Value from XXX "
when some one clicks on the dependent combo box without selecting the value from the first box.

Please let me know how I can achieve this in Excel.

Thank you,
Sar

 

[RSXchin]

you mean a msgbox?

msgbox ("This is the text that shows up", "This is the title", vbyesno)

 

[Rick Rothstein]

you mean a msgbox?

msgbox ("This is the text that shows up", "This is the title", vbyesno)

@Sar,

You will want to check out the MsgBox in the VB help files as the syntax RSXchin showed you is incorrect (the items are out of order and surrounding the arguments with parentheses will make the command fail); but, more importantly, there are lots of useful options available with this function that you will want to explore. The easy way to get to the help files is to type msgbox in any VB code window and then, with the text cursor in or next to the word, press F1.

 

[RSXchin]

I'm sorry, I am fail

 

[saraf]

I am new to VB and trying to learn as much as I can. can you pls provide me the links which explains how I can get the msg box pop up.
As you stated "You will want to check out the MsgBox in the VB help files" where I can find the VB help files. Please advice me.

thank you.

 

[Rick Rothstein]

As you stated "You will want to check out the MsgBox in the VB help files" where I can find the VB help files. Please advice me.

You stopped reading my posting too soon... I explained how in the last sentence. Here it is again...

"The easy way to get to the help files is to type msgbox in any VB code
window and then, with the text cursor in or next to the word, press F1."<!-- / message -->

 

[saraf]

Thank you Rick very much.