Control Toolbox ListBox Properties Blank

  • Thread starter Thread starter pjhageman
  • Start date Start date
P

pjhageman

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
 
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.
 
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.
 
Back
Top