Can you not just put ='Sheet1'!A1 or whatever the cell reference is?

"Sez" wrote:

I have created a drop down list/box in excel. However, I am trying get a
cell on another worksheet to read whatever gets chosen in the drop down list
box. I have found a visual basic code for doing it using a list box, but
can't seem to get it to work using a drop-down box.

Any help would be gratefully appreciated.