textbox blank until I type in it

Hello,

I have created a vba code to lookup data and then return it in a textbox. It works perfectly once I have typed in the textbox but appears blank before I do so.

Any suggestions or ideas to solve this?

Thanks

Z