close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()