![]() |
call macro to format form
I need to be able to update the formatting of all textboxes on a form if an
individual changes the value. Currently I have a procedure that is called when each textbox is altered (NP1) but as I have 42 textboxes I was wondering if there was an easier way than assigning it individually as I have done Private Sub NP1_AfterUpdate() Call FormatPrices End Sub Private Sub NP2_AfterUpdate() Call FormatPrices End Sub Private Sub NP3_AfterUpdate() Call FormatPrices End Sub Private Sub NP4_AfterUpdate() Call FormatPrices End Sub Any suggestions would be greatly appreaciated |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com