ExcelBanter

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

Les

Combo box
 
I have 2 combo boxes which work correctly, but whenever I do a PrintPreview, Print, or run a macro etc., it selects the first item in the first column that matches the value in the second column.
This is frustrating as it is linked to a cell with a value; consequently the right value is always shown, but the text changes.
Can someone please help.
Some properties a- BoundColumn 2; Column Count 3; Col Widths 85pt;0pt;30pt.

I am prepared to email a cutdown version of this spreadsheet to anyone who may need it to help solve this problem.
--
Les



Expand AllCollapse All
--
Les

mangesh_yadav[_36_]

Combo box
 
its difficult to say anything unless i can see the actual code.

- Manges

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 05:21 PM.

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