#1   Report Post  
Posted to microsoft.public.excel.misc
sedonovan
 
Posts: n/a
Default Combo boxes

Is is possible to copy a combobox (and all its properties) into a whole
column? Each cell should have the drop down button.

Many thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Combo boxes

You can do that with Data/Validation on the Excel menu by pre-selecting the
range that requires the drop-down list and specifying the range where the
list is located.
--
Kevin Backmann


"sedonovan" wrote:

Is is possible to copy a combobox (and all its properties) into a whole
column? Each cell should have the drop down button.

Many thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
sedonovan
 
Posts: n/a
Default Combo boxes

thanks, but I need a combobox so that it can perform auto-complete or match
entry...

"Kevin B" wrote:

You can do that with Data/Validation on the Excel menu by pre-selecting the
range that requires the drop-down list and specifying the range where the
list is located.
--
Kevin Backmann


"sedonovan" wrote:

Is is possible to copy a combobox (and all its properties) into a whole
column? Each cell should have the drop down button.

Many thanks

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
Macro that can run combo boxes simonsmith Excel Discussion (Misc queries) 0 June 5th 06 05:00 PM
Nesting Combo Boxes /Returning an Array ELMONDO SNITHER Excel Discussion (Misc queries) 1 June 30th 05 01:15 AM
connecting combo boxes to yield data in another cell. TxN8tv Excel Discussion (Misc queries) 0 March 14th 05 04:07 PM
dynamic combo boxes tjb Excel Worksheet Functions 2 January 25th 05 07:33 PM
How do I autofill combo boxes with their destination cell? Defoes Right Boot Excel Worksheet Functions 3 January 10th 05 12:49 PM


All times are GMT +1. The time now is 12:58 AM.

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

About Us

"It's about Microsoft Excel"