I have a listbox on a worksheet which is populated using .additem in
code. I think i'm right in saying that you cannot put column headers in
when it is done this way. This beng so I thought I would just create
Labels and place them over the top of where the headers would be.
However the Listbox always seems to sit on top of the labels and when
trying 'Bring to Front' or 'Send to Back', they still sit beneath the
listbox. Is there anyway to change this?

Cheers in advance.


--
Jimbo1
------------------------------------------------------------------------
Jimbo1's Profile: http://www.excelforum.com/member.php...o&userid=30637
View this thread: http://www.excelforum.com/showthread...hreadid=536304

Why not just put the labels slightly above the listbox so that both are always
visible?

Jimbo1 wrote:

I have a listbox on a worksheet which is populated using .additem in
code. I think i'm right in saying that you cannot put column headers in
when it is done this way. This beng so I thought I would just create
Labels and place them over the top of where the headers would be.
However the Listbox always seems to sit on top of the labels and when
trying 'Bring to Front' or 'Send to Back', they still sit beneath the
listbox. Is there anyway to change this?

Cheers in advance.

--
Jimbo1
------------------------------------------------------------------------
Jimbo1's Profile: http://www.excelforum.com/member.php...o&userid=30637
View this thread: http://www.excelforum.com/showthread...hreadid=536304

--

Dave Peterson

I have done, was just wondering if there was a way. no matter.
cheers


--
Jimbo1
------------------------------------------------------------------------
Jimbo1's Profile: http://www.excelforum.com/member.php...o&userid=30637
View this thread: http://www.excelforum.com/showthread...hreadid=536304