How to stop a userform from automatically clearing a textbox

[AndrewGKenneth]

Hi there,

I am having an odd issue with my userform. I have one textbox coded TextBox_UniqueReference3 that appears to be automatically clearing its value when I click the add command button on my userform. This is an issue because I have programmed a vlookup on TextBox_UniqueReference3.value using the change event, so when it clears itself when the add data command button is clicked users will be presented with an error message.

This is happening despite me nowhere in my code clearing this textbox. So my question is how do I code to prevent TextBox_UniqueReference3 clearing itself when my add command button is clicked?

Thanks,
Andrew

 

[My Aswer Is This]

Show us all the code you have in your Userform.