type a value into an activex textbox into a cell in another worksheet

[Tanner_2004]

I have several textboxe that is not on a userform; they reside on worksheet A. I want to format this textbox so that it only accepts numberical values (like 500,000....no dollar sign and no cents needed). After typing in the 500,000 lets say for this example, I want to paste onto a cell in worksheet B (I can actually handle this part). What i can't handle is:
Formatting the textbox so that it only accepts numbers (or display a message if a number is not entered)
Display the 500000 as 500,000 in the textbox without the user having to enter a comma
Hiiting enter or tab to get the value from the textbox into the cell in worksheet B. It only pastes it into worksheet B when a click on another cell. That doesn't seem like the right way to enter data.

Thank you for reading and helping. It is always very much appreciated. I am wondering if I just shouls have used a userform and added by controls onto it. I have 8 sets of 5 user controls; I thought this would be easier.

Thanks again!