Hi Everyone, I could really use some help.
I'm still pretty new with VBA and Add-ins.

I have been making an Add-in to transform the current data on the active sheet of a variable workbook,
when i run the macro it does exactly what i want on the active sheet (Sheet1) of that moment.

I made a UserForm to populate certain cells, coz this info is not already available in the existing data.
When I move to the next sheet I want to run the macro (add-in) again, but this time when the Userform activates,
I want to populate the 4 Textboxes which are on the UserForm, with the data that was used to populate Sheet1.

The data which needs to populate the textboxes are on Sheet1.Range("H63:H67"),

I'm having trouble getting it done, coz of the workbook always being variable.
The things i tried all seem to get the data from the Add-in Sheet1, but no data is stored here.


Hopefully my story makes any sense at all,
hope someone can help me,
thx in advance