Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change_Event
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change_Event
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change_Event
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change_Event
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change_Event
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|