EXCEL : Combo Box

  tykesutd 19:23 05 Nov 04

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 04

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 04

Don't you see something like click here

  VoG II 22:07 05 Nov 04

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.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009