Hello All
I hope someone can help me.
Is it possible to add some code to an existing UserFrom with VBA only?
I have around 50 spreadsheets that are being used by employees to record their work. I have now written a script to make some adjustments to these sheets and update them. The intention is that I will send out a sheet with a macro that will adjust and update their time sheet for them.
The script now does almost everything I want it to, however I would like to be able to add the following code to an existing UserForm in the workbook called "NewSheet"
Private Sub UserForm_Initialize()
Me.Year.Value = ThisWorkbook.Sheets("Sheet1").Range("N15").Value
End Sub
Sorry for the long winded description but I wanted to explain why I want to make this seeming minor change through VBA.
Thanks in advance for any help you can provide.
Cheers
Jim
Bookmarks