VBA code to lock textbox in a userform which was unloaded to from another userform

[Pimp_mentality]

Good day all

I would like a macro which will lock specific textbooks in a userform from a button which was clicked in a previous userform.

eg When I click say cmd button1 in userform1 (which unloads to userform2) when userform2 opens textboxes 1, 2 & 3 in userform2 are locked (all others would be open).

any assistance would be appreciated.

[mikerickson]

Put this code in userform1. You should be aware that the Intialize event for Userform2 will run before the first TextBox is locked.

Please Login or Register  to view this content.

[Pimp_mentality]

With a little experimentation i figured it out but i will post my solution for any other person with a similar problem

Please Login or Register  to view this content.