Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox prompt when user selects data from combo box
Use the click event of the combobox if it is from the Control Toolbox
toolbar. Regards, Tom Ogilvy "tjb" wrote in message ... When a user selects data from a combo box, how can I have a message box prompt or User Form pop up? Once again I know this is an easy one but I'm still learning VBA! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox prompt when user selects data from combo box
Continuing to assume the combobox if from the Control Toolbox Toolbar
It still has a click event found in the sheet module In design mode, double click on the combobox and you should go to a code module with something like Private Sub Combobox1_Click() End Sub Put your code there. --------------------- If the combobox is actually a dropdown box from the forms toolbar, you would right click on it and select Assign Macro. then Assign the macro you want to run to the dropdown box. Regards, Tom Ogilvy "tjb" wrote in message ... Thank you for your response. The combo box is on the sheet itself, not on a user form, what would I enter for a click event? -----Original Message----- Use the click event of the combobox if it is from the Control Toolbox toolbar. Regards, Tom Ogilvy "tjb" wrote in message ... When a user selects data from a combo box, how can I have a message box prompt or User Form pop up? Once again I know this is an easy one but I'm still learning VBA! . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox prompt when user selects data from combo box
Private Sub ComboBox1_Change()
MsgBox Prompt:="You have selected " & _ ComboBox1.Value, Buttons:=vbOKOnly End Sub I chose the change event over the click event, don't know if theirs a whole lot of difference?? Dan E "tjb" wrote in message ... Thank you for your response. The combo box is on the sheet itself, not on a user form, what would I enter for a click event? -----Original Message----- Use the click event of the combobox if it is from the Control Toolbox toolbar. Regards, Tom Ogilvy "tjb" wrote in message ... When a user selects data from a combo box, how can I have a message box prompt or User Form pop up? Once again I know this is an easy one but I'm still learning VBA! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox prompt when user selects data from combo box
If you allow a user to type an entry into the combobox, it fires on every
keystroke - that would be a difference. Regards, Tom Ogilvy "Dan E" wrote in message ... Private Sub ComboBox1_Change() MsgBox Prompt:="You have selected " & _ ComboBox1.Value, Buttons:=vbOKOnly End Sub I chose the change event over the click event, don't know if theirs a whole lot of difference?? Dan E "tjb" wrote in message ... Thank you for your response. The combo box is on the sheet itself, not on a user form, what would I enter for a click event? -----Original Message----- Use the click event of the combobox if it is from the Control Toolbox toolbar. Regards, Tom Ogilvy "tjb" wrote in message ... When a user selects data from a combo box, how can I have a message box prompt or User Form pop up? Once again I know this is an easy one but I'm still learning VBA! . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox prompt when user selects data from combo box
Yep, never noticed that till now, that does suck. Thanks for pointing that
out... Dan E "Tom Ogilvy" wrote in message ... If you allow a user to type an entry into the combobox, it fires on every keystroke - that would be a difference. Regards, Tom Ogilvy "Dan E" wrote in message ... Private Sub ComboBox1_Change() MsgBox Prompt:="You have selected " & _ ComboBox1.Value, Buttons:=vbOKOnly End Sub I chose the change event over the click event, don't know if theirs a whole lot of difference?? Dan E "tjb" wrote in message ... Thank you for your response. The combo box is on the sheet itself, not on a user form, what would I enter for a click event? -----Original Message----- Use the click event of the combobox if it is from the Control Toolbox toolbar. Regards, Tom Ogilvy "tjb" wrote in message ... When a user selects data from a combo box, how can I have a message box prompt or User Form pop up? Once again I know this is an easy one but I'm still learning VBA! . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox prompt when user selects data from combo box
Thanks but how do I get different messages for different
values? -----Original Message----- Yep, never noticed that till now, that does suck. Thanks for pointing that out... Dan E "Tom Ogilvy" wrote in message ... If you allow a user to type an entry into the combobox, it fires on every keystroke - that would be a difference. Regards, Tom Ogilvy "Dan E" wrote in message ... Private Sub ComboBox1_Change() MsgBox Prompt:="You have selected " & _ ComboBox1.Value, Buttons:=vbOKOnly End Sub I chose the change event over the click event, don't know if theirs a whole lot of difference?? Dan E "tjb" wrote in message ... Thank you for your response. The combo box is on the sheet itself, not on a user form, what would I enter for a click event? -----Original Message----- Use the click event of the combobox if it is from the Control Toolbox toolbar. Regards, Tom Ogilvy "tjb" wrote in message ... When a user selects data from a combo box, how can I have a message box prompt or User Form pop up? Once again I know this is an easy one but I'm still learning VBA! . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user to input data (pop-up box) | Excel Discussion (Misc queries) | |||
Need an input box when user selects a value in a drop down box | Excel Worksheet Functions | |||
If prompt for user data | Excel Discussion (Misc queries) | |||
VB - ignore a msgbox prompt | Excel Discussion (Misc queries) | |||
Wait for user to change data after msgbox ???? | Excel Discussion (Misc queries) |