ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo box resize with cell? (https://www.excelbanter.com/excel-discussion-misc-queries/131422-combo-box-resize-cell.html)

RzB

Combo box resize with cell?
 
Is it possible to somehow associate a combo box
with a cell, such that it will automatically resize as
the cell is resized?

Many thanks,
Roy




Tom Ogilvy

Combo box resize with cell?
 
after you place the combobox (from the control toolbox toolbar), right click
on it and select Format Control, then go to the properties tab and make the
appropriate selection.

--
Regards,
Tom Ogilvy


"RzB" wrote:

Is it possible to somehow associate a combo box
with a cell, such that it will automatically resize as
the cell is resized?

Many thanks,
Roy





RzB

Combo box resize with cell?
 
Tom,
Many thanks for your response.

So are you saying that this is possible?

I have looked all through the properties but can't find
one that will cause the size of the combo box to change
when the cell size is changed.

What is ithe appropriate selection to do this?

Am I missing something?

Thanks,
Roy

"Tom Ogilvy" wrote in message
...
after you place the combobox (from the control toolbox toolbar), right
click
on it and select Format Control, then go to the properties tab and make
the
appropriate selection.

--
Regards,
Tom Ogilvy


"RzB" wrote:

Is it possible to somehow associate a combo box
with a cell, such that it will automatically resize as
the cell is resized?

Many thanks,
Roy







RzB

Combo box resize with cell?
 
Opppssss.... Found it - aplos, apols.....

Please ignore last message !!!

Apols...
Roy

"RzB" wrote in message
...
Tom,
Many thanks for your response.

So are you saying that this is possible?

I have looked all through the properties but can't find
one that will cause the size of the combo box to change
when the cell size is changed.

What is ithe appropriate selection to do this?

Am I missing something?

Thanks,
Roy





All times are GMT +1. The time now is 12:05 PM.

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