ExcelBanter - control element

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - control element (https://www.excelbanter.com/excel-programming/286799-control-element.html)

Is it possible to change the format of a combobox\listbox?
I added a list so the user can pick his name from a list.
Problem is that the worksheet is very large, so I zoom 70%.
That way the listitems and selected value looks like 7 pixels.
Is there a way to change the layout of the list?

Thnx,
Pollek

--
Message posted from http://www.ExcelForum.com

Hi polletje

If you used a combobox from the ControlToolbox toolbar then
Go into design mode, and change it in the properties

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl

"polletje " wrote in message ...
Is it possible to change the format of a combobox\listbox?
I added a list so the user can pick his name from a list.
Problem is that the worksheet is very large, so I zoom 70%.
That way the listitems and selected value looks like 7 pixels.
Is there a way to change the layout of the list?

Thnx,
Polleke

---
Message posted from http://www.ExcelForum.com/