Hi.
I've a listbox with rowsource property.
The first row of the sheet range doesn't contain data but just a heading.
I would like my list box to scroll from second row so as to have heading always on top.
I tried with "Columnhead" property but it doesn't work because it assumes that columnheads are column built-in headings (Column A, column B.....).
How can I apply columnhead property to range's first row?
If not possible, how can I change those names (Column A...) into my personalized headings?
Thank you.
Nick
I've a listbox with rowsource property.
The first row of the sheet range doesn't contain data but just a heading.
I would like my list box to scroll from second row so as to have heading always on top.
I tried with "Columnhead" property but it doesn't work because it assumes that columnheads are column built-in headings (Column A, column B.....).
How can I apply columnhead property to range's first row?
If not possible, how can I change those names (Column A...) into my personalized headings?
Thank you.
Nick