Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a ListBox
I have a ListBox on a Uerform code is:
With Me.ListBox1 ..RowSource = "A20:G50" ..ColumnCount = 5 End With This works fine but it is not very neat for what I need. I need to start by showing A20:G20 in the ListBox and then adding a row of data once the data exists. How can I do this? Also is it possible to format the indivdual columns in a ListBox, right justify, center, font etc. Perhaps a ListBox is not even the right thing to use? TIA Matthew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |