ActiveX Control Linked Cell (across different worksheets)

[jdohlinger]

Is it possible to link an ActiveX Box (a drop down menu) to a cell that lives in a different worksheet?

When I open the activeX box's properties it seems I can only link it to a cell in the workbook that had the axtiveX box was inserted into. Any help is appreciated!

 

[Case_Germany]

Hi,

write the sheet with exclamation mark (Sheet2!A1).

 

[jdohlinger]

Thanks! Worked great!