EXCEL : Combo Box

  tykesutd 19:23 05 Nov 2004
Locked

Hi
Can anyone tell me how to add a drop down list from data in another worksheet within the same workbook to a COMBO BOX

Any help would be gratefully received.
Allan

  VoG II 19:29 05 Nov 2004

Right click the box, select Format Control.

Click the symbol at the right hand end of the Input Range Box, browse to the other sheet, select all the data, click the symbol again.

  VoG II 21:33 05 Nov 2004

Don't you see something like click here

  VoG II 22:07 05 Nov 2004

Via e-mail

Hi VOG On the screen that appears on my PC there is not a "CONTROL" tab. The other four tabs are there. Cheers Allan

==========================

Please don't use the yellow envelope which is for private messages.

Try Detect and Repair on the Help menu in Excel.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

Political cartoons in 2017: Chris Riddell, Rebecca Hendin and Dave Brown on what it’s like to…

The best iPhone for 2017

Tennis : comment regarder la finale de la Coupe Davis 2017 ?