Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox
I am having problems with a combo box on a userform. I have the row source
set as the range "drwlistrng". I am having problem occassionaly when I add rows above the row source and the row source is not being shifted when rows are added. The rows are added using procedures and I do a 'stopautocalc' and 'startautocalc' with each procedure. Also the 'drwlistrng' is hidden and I unhide it when the arrow is clicked on the combo box. Any ideas on what I am doing wrong? Thanks Private Sub ComboBox1_DropButtonClick() unprotectsheet stopautocalc Range("drwlistrng").EntireRow.Hidden = False End Sub Sub stopautocalc() With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With End Sub Sub startautocalc() With Application .ScreenUpdating = True .EnableEvents = True .Calculation = xlCalculationAutomatic End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Combobox options based on the input of another combobox | Excel Programming | |||
ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming |