View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
pjhageman[_14_] pjhageman[_14_] is offline
external usenet poster
 
Posts: 1
Default Control Toolbox ListBox Properties Blank

Thanks Libby, the properties are visible, and I was able to enter th
ListFillRange – works okay; however, when I close and reopen th
workbook, the listbox does not appear, rather, ghost text from othe
cells in the worksheet appear. When I click different cells in th
worksheet, the list portion then appears. Then when I click in the u
arrow, it appears; and when I click in the down arrow place, i
appears. Other unusual things: the curser turns into a cross (versu
arrow pointer), and the first name on the list reverses colors – whit
to blue background, black to white font.

Any idea of what’s going on? I can’t figure any logic in all this.



Libby wrote:
*Hi
The only reason I can think of for this is that there is
already a vba project in the workbook which has been
locked.
In order to see the properties for the listbox on the
worksheet, you'll have to go into the VBA editor and
unlock the project with the appropriate password.
-----Original Message-----
From the Control Toolbox, I have inserted a ListBox into

a worksheet.
When I click on Propoerties, the properties come up

completely blank.
What is wrong?


---
Message posted from http://www.ExcelForum.com/

.


--
Message posted from http://www.ExcelForum.com