Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox makes Excel hang
Running Excel 2003 Professional, I have ComboBoxes in a user form with
ControlSource set to a named (single cell) range on one sheet, and RowSource set to a short list referenced by a named range on another sheet. The RowSource cells have formulas whose results vary in response to a separate ComboBox value and it's corresponding ControlSource cell. This approach worked perfectly for most ComboBoxes on the same form, but one hangs the application completely when I click on the dropdown arrow (not only when the form is loaded, but even sometimes in design view). Have to use Task Manager to escape. So, what the heck? I've checked and triple checked all the range names to be sure they still exist; that the cell address isn't maybe referenced by two different range names; that the rowsource cells' formulas return non-error values when the cell they reference is set to the value coming from the other ComboBox. I deleted the control and recreated it. Exported the form, deleted and reimported it. The only solution I've found so far is to clear the ControlSource property and use click-event code to set the cell value instead. But that seems unnecessarily clumsy. Does anyone have a good clue? Appreciate whatever you can suggest! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox makes Excel hang
What is the UserForm Code you have?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel seems to hang while running a UDF | Excel Programming | |||
Application Hang with Excel | Excel Discussion (Misc queries) | |||
Excel Attachments Hang | Excel Discussion (Misc queries) | |||
HELP PLEASE..Inserting combobox (ActiveX control) makes workbook c | Excel Discussion (Misc queries) | |||
excel hang | Excel Discussion (Misc queries) |