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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant