LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot enter input and cannot stop scroll bobbyangelo Excel Discussion (Misc queries) 3 October 13th 08 10:49 PM
Stop Formula input Gruff Excel Discussion (Misc queries) 1 November 29th 07 03:40 PM
How to Input date & Time [NOW()], then stop it updating? jonathandr Excel Worksheet Functions 3 October 23rd 06 05:41 PM
Excel writes "May 10" when I input "5-10". How to stop this? Carter Excel Discussion (Misc queries) 2 August 5th 05 06:52 PM
how do i get excel to stop changing my input 5-9 to 9-May???? molly Excel Discussion (Misc queries) 3 February 20th 05 08:26 PM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"