Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Heeeelp with combos¡¡¡
Hi, I want to put a combobox in one of my excels sheet, (a code combobox, not
a form combobox), inserting a subform and inside the subform the combobox is easy, but I dont want to use subforms, so I Have the following code: Private Sub CommandButton1_Click() If ComboBox1.Visible = True Then ComboBox1.Visible = False Else ComboBox1.Visible = True asas End If End Sub Private Sub asas() ComboBox1.AddItem "Mesones", 1 ComboBox1.AddItem "Fray Servando", 2 ComboBox1.AddItem "Empresa", 3 ComboBox1.AddItem "Israel", 4 ComboBox1.AddItem "Consumo Interno", 5 ComboBox1.AddItem "Otros", 6 ComboBox1.DropDownLines = 3 ComboBox1.DropDownWidth = 75 ComboBox1.ListIndex = 0 End Sub Could someone tell me how to do what I want to do??? PD. I also checked with private sub combobox1_initialize() giving me bad results. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Heeeelp with combos¡¡¡
How did you create this dropdown, from the controls toolbox, or via code. If
the latter, show us the code. -- HTH RP (remove nothere from the email address if mailing direct) "filo666" wrote in message ... Hi, I want to put a combobox in one of my excels sheet, (a code combobox, not a form combobox), inserting a subform and inside the subform the combobox is easy, but I don't want to use subforms, so I Have the following code: Private Sub CommandButton1_Click() If ComboBox1.Visible = True Then ComboBox1.Visible = False Else ComboBox1.Visible = True asas End If End Sub Private Sub asas() ComboBox1.AddItem "Mesones", 1 ComboBox1.AddItem "Fray Servando", 2 ComboBox1.AddItem "Empresa", 3 ComboBox1.AddItem "Israel", 4 ComboBox1.AddItem "Consumo Interno", 5 ComboBox1.AddItem "Otros", 6 ComboBox1.DropDownLines = 3 ComboBox1.DropDownWidth = 75 ComboBox1.ListIndex = 0 End Sub Could someone tell me how to do what I want to do??? PD. I also checked with private sub combobox1_initialize() giving me bad results. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro HEEEELP | Excel Worksheet Functions | |||
Help! Heeeelp! can I copy an excel macro to another computer | Excel Discussion (Misc queries) |