How to set the Column Header value for list box?

[Ai_Jun_Zhang]

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.

[Gary L Brown]

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

ColumnHeaders = True
ListFillRange = A2:A10

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
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
>
>

[Ai_Jun_Zhang]

Hi! Gary,

I did not populate the listbox from a spread sheet but in coding by calling mylistBox AddItem.

I am not sure how can I set up the Column header name if the listbox is not populate from cells in a sheet.

[Gary L Brown]

Unfortunately, per Rob Bovey [MCSE, MCSD, Excel MVP, Application
Professionals, http://www.appspro.com/], the only way that column headers in
a listbox can be
loaded is if you're using a range as your source data and the column headers
are in the first row of that range.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Ai_Jun_Zhang" wrote:

>
> Hi! Gary,
>
> I did not populate the listbox from a spread sheet but in coding by
> calling mylistBox AddItem.
>
> I am not sure how can I set up the Column header name if the listbox is
> not populate from cells in a sheet.
>
>
> --
> 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
>
>