Wait for press a key!

[Guest]

Hi All,
In VBA, how can I hold the macro until press a assigned key.
Example!
sub copy_value()
Activecell.copy
(the macro hold and waiting press a assigned key.)
activecell.select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
end if

 

[NickHK]

Why not give the user an Application.Inputbox so they can choose a range
into which the Paste goes ?
Check the help for relevant arguments.

NickHK