Example...
Put header in A1
Put list in A2:A10

ColumnHeaders = True
ListFillRange = A2:A10

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Ai_Jun_Zhang" wrote:


Hi!

I have this listbox and it only has one column.

I have columnHeads set to true. I would like to name the column name as
"Product". I do not know how can I set the value in the column header.

Please advise.

Thanks,
Aijun.


--
Ai_Jun_Zhang
------------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474
View this thread: http://www.excelforum.com/showthread...hreadid=517930