View Single Post
 
Old 02-14-2015, 02:54 PM
Sgt Rock Sgt Rock is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Nov 2013
Location: Dallas, Texas
Posts: 16
Sgt Rock is on a distinguished road
Default VBA to Format a Table Column in Excel

This should be most simplistic and I've tried several attempts at the code.
My last endeavor:

This is part of a worksheet change event if that helps, and the information is in an Excel Table.

Code:
If Not Intersect(Target, Range("DataEntry[Threshold]")) Is Nothing Then
        
            With Target
                Application.EnableEvents = False
                .NumberFormat = "#,###"
                Application.EnableEvents = True
            End With
            
    End If
The value in the column "Threshold" is calculated from a formula. I'm sure it is something ultra simple. Any assistance would be most appreciated.

Best weekend wishes, Sgt. Rock (Mort)
Reply With Quote