VBA to Format a Table Column in Excel

Sgt Rock · #1 02-14-2015, 02:54 PM

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Embedded Excel in Powerpoint - custom animation, display column by column	andytheanimal	PowerPoint	2	01-20-2015 06:30 AM
How can I temporarily break a 3 column format in order to type a single column paragraph	William P	Word	1	01-04-2015 06:40 PM
Merge From Excel With Table in Word - Next Record If Excel Column Same?	misscrf	Mail Merge	2	10-15-2014 11:51 PM
1.image in a table 2.right click 3.menu click format 4.a format column appears	OldFatDog	Drawing and Graphics	1	06-13-2014 11:19 PM
Updating excel link alters table format in PP	dbmagnus	PowerPoint	0	06-03-2010 12:12 PM