Message Box on Drop Down Selection

[leighjones123]

Hi All

I've got a user form in VB/Excel. When the user selects one of the options, i need a message box to pop up to give them information.

How would i go about this?

I'm very much a VB Beginner!

Thanks

 

[adam087]

You'd put your code in the 'Change' event

Private Sub ComboBox1_Change()
 
'Your code such as...
MsgBox "You selected an item!"
 
End Sub

Regards
Adam

 

[leighjones123]

Adam

That's great thankyou - quick query.

Is there any way i can get it to only pop up when a particular option on my dropdown has been selected?

Many thanks for your quick response,

Leigh

 

[adam087]

Yeah. You'll want to play with it but try looking at...

Private Sub ComboBox1_Change()
 
Select Case ComboBox1
 
Case "Hello"
MsgBox "You clicked Hello!"
 
Case "Goodbye"
MsgBox "You clicked Goodbye!"
 
Case "Do Nothing"
'Do nothing
 
Case Else
MsgBox "You clicked something else!"
 
End Select
 
End Sub

Regards
Adam