make xlam store inserted text to itself rather than open workbook

I'm not even sure this is possible, but here goes...
I have an add in with a userform where you enter a reminder and set a time for the reminder to pop up, currently the reminder text is saved in the active sheet, which means the active sheet of whichever workbook is open at that momentm
I want the reminder text to save to the add in file rather than the open workbook...
Is this possible. And if so, please help with the code to make it happen.
Sorry for not uploading my example, new it rules at work prohibits me from doing so, so I'm working off my phone at the moment.

ANDREAAS

yes it is possible. Use

ThisWorkbook.Sheets("Sheet1").Range("A1").Value = "reminder text" 'change to your range

Thisworkbook.Save ...........

Think I need a pair of opposable legs rather than thumbs, so I can kick myself... I did not even consider the "thisworkbook" procedure.

Thank you cobralad, I'll try it out.
1000000 million rep, coming your way

Sorry I only have 1000000 rep left, so you guys, cobralad and buran wil have to share lol

Sorry guys, seems I was a bit zelous with my celebration...
I tried the code that cobralad and buran provided, but the values still save to the currently open workbook rather than the xlamm thank for your efforts anyway!
Any other ideas?

Sorry buran. It works 100%. I added some other code which caused the problem afterwards.

Thanks again for the help. You rock!!!

Sorry buran. It works 100%. I added some other code which caused the problem afterwards.

Thanks again for the help. You rock!!!