ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combobox; Display all entries when the down arrow is clicked. (https://www.excelbanter.com/excel-programming/276734-combobox%3B-display-all-entries-when-down-arrow-clicked.html)

Jeff Marshall[_2_]

Combobox; Display all entries when the down arrow is clicked.
 
Hi,
I have a combox that is filled with entries from cells in sheet3 from A1 to
A499.
I can load the entries OK, but when you click on the down arrow to see them,
it displays only a single column so all the entries cannot be seen at one
time.

Is there a way that I could make 5 or 6 columns when the entries are
displayed so that the user can see all the data at once ??

Thanks in advance for any help offered.
Jeff



Dick Kusleika

Combobox; Display all entries when the down arrow is clicked.
 
Jeff

That would be cool, but no.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Jeff Marshall" wrote in message
...
Hi,
I have a combox that is filled with entries from cells in sheet3 from A1

to
A499.
I can load the entries OK, but when you click on the down arrow to see

them,
it displays only a single column so all the entries cannot be seen at one
time.

Is there a way that I could make 5 or 6 columns when the entries are
displayed so that the user can see all the data at once ??

Thanks in advance for any help offered.
Jeff






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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com