Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox and if
How can i write a code for a ComboBox with two values Yes and No, when I choose Yes I get Cell A1 and when I choose No I get 0.000? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox and if
Hi
I am slightly modifying the code from an earlier reply to your question. It is not clear what you mean by 'get' but instead I will just use the Message box to display. Private Sub ComboBox1_Click() Select Case ComboBox1 Case "Yes" Msgbox Sheet1.Cells(1,1).value Case "No" Msgbox "0.000" End Select End Sub " wrote: How can i write a code for a ComboBox with two values Yes and No, when I choose Yes I get Cell A1 and when I choose No I get 0.000? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Combobox options based on the input of another combobox | Excel Programming | |||
ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming |