Excel macro; automatically add text to number in column
Closed
pldhrcel
Posts
1
Registration date
Tuesday December 13, 2016
Status
Member
Last seen
December 13, 2016
-
Updated by TrowaD on 19/12/16 at 11:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2016 at 11:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2016 at 11:44 AM
Related:
- Excel macro; automatically add text to number in column
- Pdf and xps add in 2007 - Download - Other
- Spell number in excel without macro - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to add @ in laptop - Guide
- Macros in excel download - Download - Spreadsheets
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Dec 19, 2016 at 11:44 AM
Dec 19, 2016 at 11:44 AM
Hi pldhrcel,
Try the following code:
Right-click the sheets tab and select View Code, the paste the code in the big white field. Now enter a number in column J and see what happens.
Best regards,
Trowa
Try the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("J:J")) Is Nothing Then Exit Sub
If Target.Cells.Count > 1 Then Exit Sub
If Target.Value = vbNullString Then Exit Sub
If IsNumeric(Target.Value) = True And Right(Target.Value, 5) <> "Failed" Then
Target.Value = Target.Value & " Failed"
End If
End Sub
Right-click the sheets tab and select View Code, the paste the code in the big white field. Now enter a number in column J and see what happens.
Best regards,
Trowa
