Thread: stop for input
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curt Curt is offline
external usenet poster
 
Posts: 469
Default stop for input

have the following macro built with excel want to stop in (A2) to enter text
then return to M132. This is test range to establish function Have (A2)
formated for given amount of text. Not sure of code to allow text entry Runs
thru without stop.
Thanks


Range("N132").Select
Sheets("Desc").Select
Range("A2").Select

ActiveCell.FormulaR1C1 = ""
Range("A2").Select
Selection.Cut
Sheets("Data").Select
Range("M132").Select
ActiveSheet.Paste
End Sub