EXCEL : Combo Box

  tykesutd 19:23 05 Nov 04
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 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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…