How to fill combobox with values ?

[audrey]

Hello,

1. How can I fill the combobox with values ? (EDIT: I did it from Properties)
2. and secondly if chosen value b (among a,b and c) what is the enxt steps to write the macro ?

Thank you

 

[Smitty]

2. and secondly if chosen value b (among a,b and c) what is the enxt steps to write the macro ?

What do you want the macro to do?

Note that an easy way to trigger a macro with a list selection is to use a Change event coupled with a Data Validation drop-down box, as opposed to a ComboBox.

 

[audrey]

is it A1.value = true ?

 

[audrey]

well according to the value chosen inside the combobox, few cells will be hidden or revealed. I know the macro hides and unhides the cells, but I forgottten how to choose the value in combobox.

 

[Smitty]

Here's one way:

Private Sub ComboBox1_Change()
    MsgBox ComboBox1.Value
End Sub

The other way would be

MsgBox [A1].Value

If A1 is your linked cell.

 

[audrey]

Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
Case "Date"
Call Macro12
Case "Name"
Call Macro13
Case "Type"
Call Macro14
End Select

End Sub

why this one not working ???

 

[Smitty]

What happens?

What does this do for you:

<font face=Calibri><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> ComboBox1_Change()<br>    <SPAN style="color:#00007F">Select</SPAN> <SPAN style="color:#00007F">Case</SPAN> ComboBox1.Value<br>        <SPAN style="color:#00007F">Case</SPAN> "Date"<br>            MsgBox "Date"<br>            <SPAN style="color:#007F00">'Call Macro12</SPAN><br>        <SPAN style="color:#00007F">Case</SPAN> "Name"<br>            MsgBox "Name"<br>            <SPAN style="color:#007F00">'Call Macro13</SPAN><br>        <SPAN style="color:#00007F">Case</SPAN> "Type"<br>            MsgBox "Type"<br>            <SPAN style="color:#007F00">'Call Macro14</SPAN><br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Select</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>