I am trying to change a cell's NumberFormat within the
WorksheetChange_Event. The format is changed, but it is
not reflected in the cell until the next time I change the
cell. Any ideas on how to make the NumberFormat be
applied and used immediately after the cells value is
changed? TIA

Hawk,

I used the following and the format changed instantly when I hit the Enter
key (using Excel97):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.NumberFormat = "00000#"
End Sub

--
sb
"Hawk" wrote in message
...
I am trying to change a cell's NumberFormat within the
WorksheetChange_Event. The format is changed, but it is
not reflected in the cell until the next time I change the
cell. Any ideas on how to make the NumberFormat be
applied and used immediately after the cells value is
changed? TIA

I forgot to mention that I am using Excel 97. It seems to
work for 2000, but not 97...Any ideas for a workaround?
-----Original Message-----
Hawk,

I used the following and the format changed instantly
when I hit the Enter
key (using Excel97):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.NumberFormat = "00000#"
End Sub

--
sb
"Hawk" wrote in
message
...
I am trying to change a cell's NumberFormat within the
WorksheetChange_Event. The format is changed, but it is
not reflected in the cell until the next time I change
the
cell. Any ideas on how to make the NumberFormat be
applied and used immediately after the cells value is
changed? TIA


.

It works fine in xl97 if the change is made by editing the cell.

how are you updating your cell?

--
Regards,
Tom Ogilvy

Hawk wrote in message
...
I forgot to mention that I am using Excel 97. It seems to
work for 2000, but not 97...Any ideas for a workaround?
-----Original Message-----
Hawk,

I used the following and the format changed instantly
when I hit the Enter
key (using Excel97):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.NumberFormat = "00000#"
End Sub

--
sb
"Hawk" wrote in
message
...
I am trying to change a cell's NumberFormat within the
WorksheetChange_Event. The format is changed, but it is
not reflected in the cell until the next time I change
the
cell. Any ideas on how to make the NumberFormat be
applied and used immediately after the cells value is
changed? TIA


.

Thanks for responding, but I found the error. I truely
appreciate all your help...


-----Original Message-----
It works fine in xl97 if the change is made by editing
the cell.

how are you updating your cell?

--
Regards,
Tom Ogilvy

Hawk wrote in
message
...
I forgot to mention that I am using Excel 97. It seems
to
work for 2000, but not 97...Any ideas for a workaround?
-----Original Message-----
Hawk,

I used the following and the format changed instantly
when I hit the Enter
key (using Excel97):

Private Sub Worksheet_Change(ByVal Target As
Excel.Range)
Target.NumberFormat = "00000#"
End Sub

--
sb
"Hawk" wrote in
message
...
I am trying to change a cell's NumberFormat within
the
WorksheetChange_Event. The format is changed, but
it is
not reflected in the cell until the next time I
change
the
cell. Any ideas on how to make the NumberFormat be
applied and used immediately after the cells value is
changed? TIA


.



.