Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding items to columns in a listbox
I have a two column listbox, called Listbox1.
I want to add the headers to the column heads, and then I want to add data from my worksheet (but I don't want it bound to the data). However, I'm not sure on the syntax The column headers are "Company" and "SIB" And the values in the first row would be Range("A2").value and Range("B2").value Could someone please help? Thanks Daniel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding items to columns in a listbox
Column headings can only be specified if you use the .listfillrange/.rowsource.
Maybe you could add a label above the listbox? Daniel Bonallack wrote: I have a two column listbox, called Listbox1. I want to add the headers to the column heads, and then I want to add data from my worksheet (but I don't want it bound to the data). However, I'm not sure on the syntax The column headers are "Company" and "SIB" And the values in the first row would be Range("A2").value and Range("B2").value Could someone please help? Thanks Daniel -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DONT WANT TO SEE LISTBOX SELEXTED ITEMS WHEN COME BACK TO LIST BOX | Excel Discussion (Misc queries) | |||
filtering to show items in a listbox | Excel Discussion (Misc queries) | |||
Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
Deleting Duplicate items in a ListBox | Excel Discussion (Misc queries) | |||
Problem using INDEX to select items in listbox | Excel Discussion (Misc queries) |