Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo text value disappears when wkb opens??!
Hi,
I haven't been able to find anything on this in the forum. My situation is that I have a combo box control on a sheet. The combo list is populated by querying an access db when the combo is activated, the combo has 3 columns, column 1 is bound (which is linked to a cell in the wkb), column 2 is user info only, column 3 is set as TextColumn. It's all working great until I close the workbook and reopen it (after having saved). When the sheet first pops up the combo displays the column 3 text value as it did before it was closed, but as the workbook finished loading all of a sudden the combo loses its text value and displays the bound value. I have tried opening the book with macros disabled to see if it is my code which is causeing the problem, but the result is the same. I also have another combo on the sheet which only shows one column, the bound column, and it does not have the same problem, it works just as I would expect. If anyone has an idea of what I can do to fix this I would be most appreciative. Regards Henry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo text value disappears when wkb opens??!
My guess would be to call the macro that does the query to populate the
ComboBox at the WorkBook_Open Event. Mike F "hef" wrote in message oups.com... Hi, I haven't been able to find anything on this in the forum. My situation is that I have a combo box control on a sheet. The combo list is populated by querying an access db when the combo is activated, the combo has 3 columns, column 1 is bound (which is linked to a cell in the wkb), column 2 is user info only, column 3 is set as TextColumn. It's all working great until I close the workbook and reopen it (after having saved). When the sheet first pops up the combo displays the column 3 text value as it did before it was closed, but as the workbook finished loading all of a sudden the combo loses its text value and displays the bound value. I have tried opening the book with macros disabled to see if it is my code which is causeing the problem, but the result is the same. I also have another combo on the sheet which only shows one column, the bound column, and it does not have the same problem, it works just as I would expect. If anyone has an idea of what I can do to fix this I would be most appreciative. Regards Henry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo text value disappears when wkb opens??!
Yeah, that would be an option, I can certainly work around it, but I am
confused by the behaviour so I was hoping to see if anyone had an explanation for it so I could avoid just adding more code. Thanks for the response. Henry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text box disappears with 2 columns | Excel Discussion (Misc queries) | |||
Combo box disappears after selection made | Excel Discussion (Misc queries) | |||
All text disappears when wrap text in excel is used | Excel Worksheet Functions | |||
Text box disappears | Charts and Charting in Excel | |||
Text disappears when word wrap is used | Excel Discussion (Misc queries) |