Validation drop down box too large

[Depley]

I have made drop down boxes for several columns in a workbook. The problem
is that the drop down box is too wide. For example, for a simple "Yes,No"
selection the drop down box is +/- 7 inches wide. Can I size the driop down
box to simply be the width of the column it is referring to? I have looked
everywhere, and in the process learned many things but have not found an
answer to my delemma. Any help would be greatly appreciated.

 

[Roger Govier]

Hi

How did you create the dropdowns, with Data Validation or Combobox?
If ComboBox, then you can adjust the width of that when in Design mode.

If Data Validation, then take a look at Debra Dalgleish's site.
She has code there for making the box wider, but just change the values to
get the size of columns you wish.
http://www.contextures.com/xlDataVal08.html#Wider

 

[Depley]

Hi

How did you create the dropdowns, with Data Validation or Combobox?
If ComboBox, then you can adjust the width of that when in Design mode.

If Data Validation, then take a look at Debra Dalgleish's site.
She has code there for making the box wider, but just change the values to
get the size of columns you wish.
http://www.contextures.com/xlDataVal08.html#Wider

--
Regards
Roger Govier



The drop downs were created with Data Validation. I have four columns with drop down boxes that all have the same problem, i.e., the drop down box is +/- 7 inches wide and the column may be 1" wide. I have done many spreadsheets with drop down boxes but have never had this problem. I am using OfficePro 2003. If I use your solution I assume I would have to insert this code for each column?

 

[Debra Dalgleish]

Extra wide dropdown lists appear occasionally, usually if cells on the
worksheet have been merged (not necessarily the cell with the data
validation).

To get rid of them, you may have to delete the row or column and
recreate the data validation.

There's a bit more information here:

http://www.contextures.com/xlDataValWidth.html

 

[Depley]

Extra wide dropdown lists appear occasionally, usually if cells on the
worksheet have been merged (not necessarily the cell with the data
validation).

To get rid of them, you may have to delete the row or column and
recreate the data validation.

There's a bit more information here:

http://www.contextures.com/xlDataValWidth.html



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thank all who responded. There were two merged cells but unmerging them did not work. Deleting the drop down validations and then reinserting new validation drop down boxes did not work. Nothing worked but Debra's response got me thinking, I inserted another worksheet, deleted all validations from the columns, copied the entire worksheet and pasted to the new worksheet, and then added back my validation drop down lists. All in the world is good again!!!!! Thank you.

 

[Debra Dalgleish]

You're welcome, and thanks for descibing how you solved the problem.