ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to hide a column in combobox? (https://www.excelbanter.com/excel-programming/383582-how-hide-column-combobox.html)

Jignesh Gandhi

How to hide a column in combobox?
 
Hi

I fetch the data from the database and bind it to a dropdown. The
dropdown value and text are different. So I've created two columns in
dropdown. The data is bound properly but I'm unable to hide the second
column i.e. value column. So how can I hide a column in dropdown?

Jignesh


merjet

How to hide a column in combobox?
 
Set its ColumnWidth property to 0, e.g.: 30 pt; 0 pt

Hth,
Merjet



Jignesh Gandhi

How to hide a column in combobox?
 
On Feb 20, 12:17 pm, "merjet" wrote:
Set its ColumnWidth property to 0, e.g.: 30 pt; 0 pt

Hth,
Merjet


Merjet

Thanks. Got the solution.

Jignesh



All times are GMT +1. The time now is 08:13 PM.

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