Userform List box question

[ribhead]

Is there a way to tell the list box what the header is? I'm picking data from a list and putting the data in a list box and I want to name the header manually. Any thoughts?

For just $19.95 you too can have a beautiful smile.

 

[Zathras]

Simplest way is to have your data on a worksheet and reference it with the RowSource property. Then put your header row in the row above.

For example, if you have the following on a worksheet:

      B        C
145

[blue]

  Number   Name

[/color]

146

[blue]

  12345    Jones

[/color]

147

[blue]

  12346    Smith

[/color]

148

[blue]

  12347    Green

[/color]

149

[blue]

  12348    Brown

[/color]
Then set the listbox properties like this (note that the RowSource does NOT include the column heads):

  ColumnCount:

[blue]

2

[/color][/code]
ColumnHeads: [/code][blue]

True

[/color][/code]
RowSource: [/code][blue]

Sheet1!B146:C149

[/color]
Then you should get the result you want.

 

[ribhead]

This won't work for what I'm doing Zathras. I understand what you have but I'm picking certain items from a row so the item directly above the row source may not be the header. Any other ideas??

For just $19.95 you too can have a beautiful smile.

 

[Zathras]

Use a hidden sheet or some area on your sheet which is out of the way and not in use. You can then remove the sheet or clear the range when you close the form.