Require vba solution for text box "text" transfer to cell

I have the first problem with this issue solved. I am transferring text typed into a "text box" to a cell with this piece of vba.

Please Login or Register  to view this content.

To be clear - the text box named "R_BW_FOcus" transfers the text to cell A114.

THE PROBLEM
After the user types the text in the text box I need the code above to transfer the text to the cell A114. The only way I know how to do this is to create a button and get the user to click the button to activate the the vba to transfer the text.

My issue here is if the user forgets to press the button, the text won't transfer. I would like some vba that will automatically transfer the text with out the user having to do anything to play the macro.

That sounds like exactly what I need. I'm trying to make it work now but I'm not getting it right. I went into module 1 and typed the following:

Please Login or Register  to view this content.

Was writing it in Module 1 incorrect or is the way I have it written incorrect? Sorry I should mention I'm a "figure it out as you go" vba guy with no real formal training.

**note - to be clear the "omit" is there as a replacement for the purposes of posting

Thanks for the heads up Cutter - I will be sure to apply the code tags in future