Indent when ">" is typed in Column A

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Indent when ">" is typed in Column A

FAQ

Thread Tools

Display Modes

04-05-2021, 12:18 PM

Purfleet

Windows 10 Indent when ">" is typed in Column A

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

How about the below, in the worksheet you want it to work on (also example uploaded)

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

    On Error Resume Next

    If Target.Column = 1 Then
        If Left(Target.Value, 1) = ">" Then
        
            Target.InsertIndent 10 
        
        End If
        
    End If

End Sub

Attached Files

Indent_Purfleet.xlsm (16.5 KB, 8 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date	trevorc	Excel Programming	1	03-04-2021 02:39 PM
Formula to format "I" column based on if "F" column row is not blank	ravl13	Excel	3	08-22-2017 12:26 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM
the character "v" when typed acts like ctrl-v.	jim redfield	Word	1	09-22-2012 05:19 AM
Why the "decrease indent" doesn't affect the selected text to move????	Jamal NUMAN	Word	0	07-12-2011 04:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:25 PM.