ExcelBanter - data validation, list box

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - data validation, list box (https://www.excelbanter.com/new-users-excel/35983-data-validation-list-box.html)

Hekke

data validation, list box

When I make a list box from "data validation"
"allow=List"
"Source=Data"
I get a standard list box. How can I resize this default listbox ??

Bob Phillips

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

--
HTH

Bob Phillips

"Hekke" wrote in message
...
When I make a list box from "data validation"
"allow=List"
"Source=Data"
I get a standard list box. How can I resize this default listbox ??

All times are GMT +1. The time now is 10:57 AM.