How do i add a sheet and add values to the cells before it appears?

I have a userform that adds a sheet by pressing commandbutton_addsheet and the name of the sheet will be dependent on textbox_NewSheetName.value.

But what additional code do I need if I want the sheet to have some contents already in it before it becomes visible?

something like:

Please Login or Register  to view this content.

I tried:

Please Login or Register  to view this content.

Did not work, what do i need to write?

Hi,

i need index match sheet to sheet.