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