Have use ever used a userform in VBA. The Refedit feature will allow you to
select a cell in a workbook.

In the VBA window
1) Insert Userform
2) Select Toolbox (hammer and wrench icon)
3) Place Refedit on userform
4) Place command button on userform
5) double click control button so code window opens. Put in code
userform1.hide (returns to main module)

The VBA code is
userform1.Refedit1.show

mycell = userform1.Refedit1.value


"Lisa" wrote:

HELP! I'm trying to write a macro that will let the user jump to another
worksheet, select a value in a cell (which may be different each time) and I
would like the macro to input the selection on the original worksheet. The
worksheets are in the same workbook.
--
Lisa