Wait for press a key!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top