Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Toolbox ListBox Properties Blank
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Toolbox ListBox Properties Blank
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shrinking Listbox from Control Toolbox | Excel Discussion (Misc queries) | |||
Where is the control toolbox? | New Users to Excel | |||
Where is the control toolbox? | New Users to Excel | |||
Properties Page is blank for check box Control, other controls | Excel Programming | |||
control toolbox | Excel Programming |