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

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

software

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