Thanks Ryan.
I put the code in, got out of design mode, saved, closed and reloaded the
sheet but the combobox is still empty...

"ryguy7272" wrote:

Right click the grey-space near one of your toolbars, and select Control
Toolbox. Then add a ComboBox. Right-click the sheet tab and paste this code
into the window that opens:

Private Sub Worksheet_Activate()
ComboBox1.Clear
ComboBox1.AddItem "This"
ComboBox1.AddItem "That"
ComboBox1.AddItem "The Other Thing"
ComboBox1.Text = ComboBox1.List(0)
End Sub


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Benway" wrote:

"Benway" wrote:

I would add that example one uses a combo box that is "cell linked" to $A$1,
but Excel doesn't seem to recognize the combo box changing that cell as a
Worksheet change event and nothing happens.


Example two gives me an "object required" error on the first line.