Hi Rick
Please take a look at the following:
1)
Answer = InputBox("Tell me a sheet name")
'the Answer is"XXXX"
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(R[1]C,'"What do I put HERE ???"'!R2C1:R255C3,3,FALSE)"
2) why can't i simply (simply?) click on the sheet?
Rick Rothstein (MVP - VB) said:
Another possibility... Execute this statement in your macro at the point
you
want to get the sheet name...
Answer = InputBox("Tell me a sheet name")
and then reference that sheet in your code using this Worksheets(Answer).
As
an example...
Worksheets(Answer).Range("D4").Value = "Hello"
You will probably need to put some error checking code in just in case
your
user types the sheet name in wrong though.
Rick