Archive of Mr Excel Message Board
Back to Controls in Excel archive index
Back to archive home
Mystry in a Combo BoxPosted 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 BoxPosted by Dave Hawley on April 13, 2001 3:15 AM
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
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.