MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Mystry in a Combo Box

Posted by Malc on April 13, 2001 3:00 AM

A userform among other things has a combo box that .additem the contents of a select cell. It works fine until the user Freezes Panes and the button kicking off the user form is on the frozen bit of the screen and the selected cell is on the unfrozen bit. when the pane is frozen the .additem seems to pick up everything from where the the cell would be if the pane wasn't frozen down to where the select cell is. Similar things happen when the window is split. Why is this and how do I stop it.

Posted by Dave Hawley on April 13, 2001 3:15 AM

Hi Malc

I haven't experienced your problem, but If you are filling the Combobox with the users selection, try this.

Private Sub UserForm_Initialize()
ComboBox1.RowSource = Selection.Address
End Sub

OzGrid Business Applications