EXCEL : Combo Box

  tykesutd 19:23 05 Nov 2004

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.

  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

OnePlus 6 review: Hands-on

How to add texture to hand-drawn artworks

Best free iPad apps 2018

Comment créer un compte PayPal pour payer en ligne ?