Thread: list box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveInConstruction
 
Posts: n/a
Default 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.