ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   call macro to format form (https://www.excelbanter.com/excel-programming/369559-call-macro-format-form.html)

David Adamson[_5_]

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