Excel - Combo Box

I am using a combobox control.  I want an event to fire only when the
value(or text) of that combo box is changed by the user, i.e. not when it is
loaded using AddItem.  I recall that this is possible, possibly using either
Keyup or Keydown.

Can someone knowlegable supply with some example code.

Many thanks,

Paul Smith

  Paul W Smith replied to Paul W Smith

Solved my own question..... I was over complicating things, it was the
combobox Click event I needed.

combobox Excel Is it possible to have a dropdown list or another combobox within a combobox. I have a combobox with a linked cell that I use with a Hyperlink. But my project first requires me to make a selection within my combobox then another selection based on the first selection. Hope I not too confusing. Thanks Bobby contextures.com / xlDataVal02.html - - Wigi http: / / www.wimgielis.be = Excel / VBA, soccer and music keywords: combobox description: Is it possible to have a dropdown list or another combobox within a combobox. I have a combobox with a linked cell that I use with a Hyperlink. But

ComboBox geht nicht richtig Excel Hallo, ich habe eine Userform erstellt mit einer ComboBox, der ComboBox den Datenbereich f = FCr das Pulldown-Men = FC mit AK4:AK20 (unter "RowSource" bei den Eigenschaften der ComboBox) eingegeben. Ausprobieren im Tabellenblatt, alles o.k. Ich speichere ab und beim nochmaligen Ausprobieren der Userform mit der ComboBox kommt im Pulldown-Men = FC nur ein leerer Bereich. Auch ein L = F6schen der UserForm der gleichen Datei hat auch ComboBoxen, da geht es komischerweise. Auch ein Herauskopieren einer funktionierenden ComboBox in die UserForm, die nicht geht, brachte auch kein Funktionieren. Was ist da los? Excel - German Discussions ComboBoxen (1) FCltigen (1) ComboBox (1) CombBox (1) FCr (1) Herauskopieren (1) Tabellenblatt (1) Eigenschaften (1) i Hallo, ich bins nochmal. Ich habe noch etwas herausgefunden. In der nicht funktionierenden ComboBox wird der Bereich AK4:AK20 vom Tabellenblatt 2 angezeigt. Wie kann ich der ComboBox mitteilen

For each combobox Excel Bonjour, J'ai 6 combobox dans un userform, et j'aimerais faire une boucle sur mes combobox. Je fais For j = 3D1 to 6 i = 3D 2 If "ComboBox" & j <> "vide" Then Do While Range("B" & i).Value <> "" If "ComboBox" & j.Value <> Range("B" & i) Then Range("B" & i).EntireRow.Select Rows(Selection.Row).Delete pas m'en servir. Merci Mais = E7a ne marche pas. Excel - French Discussions Worksheets (1) ComboBox (1) Module (1) Macro (1) Proc (1) Activate (1) Delete (1) Range (1) Bonjour, Pourquoi tu obtenir ? MichD - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - 8e4a07eb-300c-465b-97e6-2d4f08679524@z37g2000vbl.googlegroups.com. . . Bonjour, J'ai 6 combobox dans un userform, et j'aimerais faire une boucle sur mes combobox. Je fais For j = 1 to 6 i = 2 If "ComboBox" & j <> "vide" Then Do

Add Two Columns of Data into a ComboBox in Userform Initialize Eve Excel I currently have a ListStyle ComboBox. The ComboBox contains product codes. I want to add a second column that describes the product code but only display the Col 1 data in the Textbox portion of the Combobox. For Example, Col. 1 Col.2 AF Aluminum Faces BP Banner Prints CC Custom Cabinets End Sub Private Sub CommandButton2_Click() If Me.ComboBox1.ListIndex < 0 Then 'nothing selected in the combobox Exit Sub End If With Me.ComboBox1 MsgBox .List(.ListIndex, 0) & vbLf & .List(.ListIndex, 1 for, Thanks! I do have a quick question though. Since the TextBox portion of the ComboBox is only large enough to display 2 letters, the drop down portion of the ComboBox is too narrow. Can I enlarge the width of the drop down view without enlarging the actual combobox width? - - Cheers, Ryan I would just widen the column a bit. But you could experiment