Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RzB RzB is offline
external usenet poster
 
Posts: 27
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,953
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.misc
RzB RzB is offline
external usenet poster
 
Posts: 27
Default 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






  #4   Report Post  
Posted to microsoft.public.excel.misc
RzB RzB is offline
external usenet poster
 
Posts: 27
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatic cell resize xman123 Excel Discussion (Misc queries) 1 July 11th 06 05:09 PM
automatic cell resize xman123 Excel Discussion (Misc queries) 1 July 10th 06 05:49 PM
I could NOT resize the axis title but excel allows me to resize gr Iwan Setiyono Ko Charts and Charting in Excel 4 June 6th 06 04:46 AM
I could NOT resize the axis title but excel allows me to resize gr Iwan Setiyono Ko Charts and Charting in Excel 0 March 15th 06 10:34 AM
Resize a cell comotoman Excel Discussion (Misc queries) 1 September 26th 05 04:30 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"