use VBA to enter cell and edit existing text

trevorc · #1 06-10-2020, 03:36 PM

Hi All,

Just trying to tweak my system a bit, I have this bit of code to add data to some cells
, after adding this i would like to enter one of those cell and start typing. If i double click the cell it will run other VBA code so don't want to have to do that to start typing. Is there a way using VBA to select the cell and have the cursor positioned at the end of the existing text ready to add more text.

Code:

If Not Intersect(Target, Sh.Range("D4:D5000")) Is Nothing Then 
          
            tttt = Format(Date, "ddmmyy")
            Sheets("Clipsal Customer").Range("A" & ActiveCell.Row) = "RMA" & tttt & "CC-"
            Sheets("Clipsal Customer").Range("B" & ActiveCell.Row) = Date
            Sheets("Clipsal Customer").Range("C" & ActiveCell.Row) = "Received for Repair"
            
            Sheets("Clipsal Customer").Range("A" & ActiveCell.Row).Select
' Code to place here to enter cell and start typing
  End If

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
2013 how to edit an existing filter	altja	Project	1	02-15-2014 07:06 AM
Enter text into next available cell in a table	molesy	Word VBA	2	09-11-2013 02:25 AM
Edit of existing report	abbertonian	Project	3	04-10-2013 07:56 AM
Check box and text box in same document ? cant edit / enter text	KennyG	Word	6	04-08-2013 10:59 AM
Enter + Alt + Enter is not working inside the text box! why????	Jamal NUMAN	Word	3	04-17-2011 05:35 PM