Autorun VB Code
Closed
nephilim3uk
venkat1926
- Posts
- 11
- Registration date
- Monday August 9, 2010
- Status
- Member
- Last seen
- October 27, 2010
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Autorun VB Code
- Vb code maker - Download
- Vb code download - Download
- Disable a cell in excel using VB code ✓ - Forum - Excel
- Conditional formatting can't caputure text...NEED VB CODE PLEASE ✓ - Forum - Excel
- Why doesn't this simple VB code work? ✓ - Forum - Office Software
1 reply
venkat1926
Aug 13, 2010 at 10:00 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Aug 13, 2010 at 10:00 PM
right click the sheet tab and click view code.
in that window copy this event code
============
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 4 Then Exit Sub
<name of the macro>
End Sub
===============
whenever you enter any entry in any cell in D and hit enter key the macro will be run.
in that window copy this event code
============
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 4 Then Exit Sub
<name of the macro>
End Sub
===============
whenever you enter any entry in any cell in D and hit enter key the macro will be run.