ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo box value disappers (https://www.excelbanter.com/excel-programming/306689-combo-box-value-disappers.html)

bwood415

Combo box value disappers
 
Question:

When I have an combo box in Excel and I chose a value for it in just
the excel sheet it works fine. However when I access the same sheet
through a hyperlink on a webpage when I chose a value and then click
on another cell the value in the combo box dissappers. When I click on
the combo box again though it shows the value. Also when I print. Any
ideas on this problem?
This also effects all combo boxs I have on the sheet. If I check a box
and then lose focus it goes away. These are all Active controls.

Any ideas?


Thank you,

bwood415

Combo box value disappers
 
Solution to this problem was to turn on the option in file types for
excel to open in same application so it would open fine in IE and
still have the controls work. You might also have to re-register the
app with running excel.exe /regserver to get rid of excel opening the
workbook twice but thats it and it will work fine.

Billy Woodhams


All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com