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 |
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 |
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 . |
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 . |
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 . . |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com