ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo box too small! (https://www.excelbanter.com/excel-discussion-misc-queries/53729-combo-box-too-small.html)

hays4

Combo box too small!
 

Hi, I have a combo box on my new excel form, where the user picks an
option.
My problem is that the options are 10-15 word sentences,
is there a way to wrap the text of each option to 2 or 3 lines deep?
:rolleyes:


--
hays4
------------------------------------------------------------------------
hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=482173


Roger Govier

Combo box too small!
 
Hi

Using Alt+Enter in a cell will insert a new line.
I don't think that it will alter how that cell value will subsequently
appear in a Combo box though.

Regards

Roger Govier


hays4 wrote:
Hi, I have a combo box on my new excel form, where the user picks an
option.
My problem is that the options are 10-15 word sentences,
is there a way to wrap the text of each option to 2 or 3 lines deep?
:rolleyes:




All times are GMT +1. The time now is 04:25 PM.

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