Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list box
To anyone out there,
I have a phone list where I can select the name of the person I wish to call using a list box, and all their details are extracted from another worksheet and displayed in near the list box. When I update the lists, or save the lists, close the worksheet and then re-open it, the list boxes shrink. I was wondering if anyone knows how to stop list boxes from resizing and becoming smaller each time the worksheet is altered or saved, closed and re-opened? Thanks in advance. Steve. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list box
Steve,
For what it's worth, a Listbox comes in two types. One type from the Forms toolbar and the other from the Control ToolBox. Both are found on the View | Toolbars menu. Assuming you have a Listbox from the Forms toolbar, then this may help... Right-click the Listbox and select "Format Control" On the Properties tab - checkmark "Don't move or size with cells" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "SteveInConstruction" wrote in message To anyone out there, I have a phone list where I can select the name of the person I wish to call using a list box, and all their details are extracted from another worksheet and displayed in near the list box. When I update the lists, or save the lists, close the worksheet and then re-open it, the list boxes shrink. I was wondering if anyone knows how to stop list boxes from resizing and becoming smaller each time the worksheet is altered or saved, closed and re-opened? Thanks in advance. Steve. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Update master list with other lists | Excel Worksheet Functions | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |