Validation ComboBox Size or alternative....?

I have a bunch of validation comboboxes on this excel spreadsheet. Because I
have the columns so small, it will not show the full length. Is there a way
for it to automatically expand?

Or is there a way to get the cells in a freeze frame to not be affected by
the resize of a column although it's in the same column?

You can use code to make the column temporarily wider. There's sample
code here:

http://www.contextures.com/xlDataVal08.html#Wider

Adam wrote:
> I have a bunch of validation comboboxes on this excel spreadsheet. Because I
> have the columns so small, it will not show the full length. Is there a way
> for it to automatically expand?
>
> Or is there a way to get the cells in a freeze frame to not be affected by
> the resize of a column although it's in the same column?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanx, it's kind of funky looking though, but I guess this will have to work
until I can find a way to reference cells.

"Debra Dalgleish" wrote:

> You can use code to make the column temporarily wider. There's sample
> code here:
>
> http://www.contextures.com/xlDataVal08.html#Wider
>
> Adam wrote:
> > I have a bunch of validation comboboxes on this excel spreadsheet. Because I
> > have the columns so small, it will not show the full length. Is there a way
> > for it to automatically expand?
> >
> > Or is there a way to get the cells in a freeze frame to not be affected by
> > the resize of a column although it's in the same column?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>