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: www.excelforum.com/member.php...oamp;userid=30637
View this thread: www.excelforum.com/showthread...hreadid=536304Why not just put the labels slightly above the listbox so that both are always
visible?
Jimbo1 wrote:
gt;
gt; I have a listbox on a worksheet which is populated using .additem in
gt; code. I think i'm right in saying that you cannot put column headers in
gt; when it is done this way. This beng so I thought I would just create
gt; Labels and place them over the top of where the headers would be.
gt; However the Listbox always seems to sit on top of the labels and when
gt; trying 'Bring to Front' or 'Send to Back', they still sit beneath the
gt; listbox. Is there anyway to change this?
gt;
gt; Cheers in advance.
gt;
gt; --
gt; Jimbo1
gt; ------------------------------------------------------------------------
gt; Jimbo1's Profile: www.excelforum.com/member.php...oamp;userid=30637
gt; View this thread: 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: www.excelforum.com/member.php...oamp;userid=30637
View this thread: www.excelforum.com/showthread...hreadid=536304
- May 16 Wed 2007 20:37
Just a quick one
close
全站熱搜
留言列表
發表留言