Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

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.

Re: Mystry in a Combo Box

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

Dave
OzGrid Business Applications

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.