View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Astericz Astericz is offline
external usenet poster
 
Posts: 1
Default resizing list width in combo box

Hi all
I need some help in resizing list width in my combo box.

I use the DATA / VALIDATION tools and choose the LIST in the validation
criteria.
The list for combo box in sheet1 is fine. It can resize according to the
column width. But something is gone wrong in sheet2. The list is "stuck" in
the width approx. 45 (compared to the column width) and won't resize.

Any help please?