Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a column in a multicolumn combobox
A number of articles/posts have hinted that you can have a multicolumn
combobox, and then set the columns that you don't want to see to size of zero. But I'm not seeing that this works--the column I want to hide still appears. Is this possible? Advice? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a column in a multicolumn combobox
Mike,
All you need to do is load multiple columns in the combobox, but don't set the columncount property, leave it at the default 1. Then just access the subsequent column as any other multi-column combobox, for example Private Sub ComboBox1_Click() MsgBox ComboBox1.List(ComboBox1.ListIndex, 1) End Sub Private Sub UserForm_Activate() Dim ary, i, j ary = [{"Bob","M", 123;"Lynne","F",898;"Amy","F",543}] With ComboBox1 .ColumnCount = 1 'not necessary, juts to prove it For i = 1 To 3 .AddItem ary(i, 1) For j = 2 To 3 .List(.ListCount - 1, j - 1) = ary(i, j) Next j Next i End With End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Mike Jones" wrote in message ... A number of articles/posts have hinted that you can have a multicolumn combobox, and then set the columns that you don't want to see to size of zero. But I'm not seeing that this works--the column I want to hide still appears. Is this possible? Advice? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding a column of hyperlinks behind a column of numbers | New Users to Excel | |||
Hiding a ComboBox with a Checkbox | Excel Worksheet Functions | |||
Display multicolumn box | Excel Programming | |||
display multicolumn box | Excel Programming | |||
Multicolumn Combo Box | Excel Programming |