code to edit code on userform

[proctk]

Hi

I have about 30 workbooks in a folder and I want to update / change some of the code. The code is attached to a button on a userform.

is this possible

Current Code

Private Sub CommandButton2_Click() 
Unload Me 

End Sub

new code

Private Sub CommandButton2_Click() 
Unload Me 
Sheets("conrolpanel").Select 
End Sub

 

[Norie]

Check this link Programming To The Visual Basic Editor .

 

[Greg Truby]

Note that you need not code to open each workbook's form and edit each form's code module. You could simply make the change to one, export it to a FRM file and then use Chip's know-how there to automate the process of deleting the old and importing a new userform into your other workbooks.