Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loosing combo box ListFillRange
My list fill range on the combo box (made with the Control Tool Box)
properties refers to another open workbook -- [statements.xls]sheet1!v2:v100 --. The workbook the combo box is in is a template. I save both worksheets as a workspace so both will always open together. Lately, when I open the workspace, the combo box has no information. When checking the properties the listfillrange is still there - but it does not display in the combo box. To "reconnect" all I have to do is CUT the listfillrange and PASTE it back in the same properties area. After that it works fine until I close the workspace again. Where am I going wrong? Thanks -- Thank You Hank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox ListFillRange | Excel Discussion (Misc queries) | |||
Combo box - Listfillrange | Excel Discussion (Misc queries) | |||
.ListFillRange as Variable ? in Listbox | Excel Programming | |||
ListFillRange | Excel Programming | |||
ListFillRange | Excel Programming |