UserForm: Command Button enters numeric value to text box

Good Evening,

UserForm1 has three text box: TxtBoxA, TxtBoxB and TxtBoxC. UserForm1 has three command buttons: CommandButton1, CommandButton2 and CommandButton3. Each button will be a assigned with a numeric value of 1,2 and 3 respectively.

My desire is when I select any TxtBox - ie TxtBoxA - with my curser and then click any CommandButton, the value of that button will be entered into the TxtBox.

The concept is similar to a number keypad. A backspace command button would be a feature, too.

So far I have this code assigned to CommandButton1:

Please Login or Register  to view this content.

However, the focus is set to TxtBoxA, only.

Thanks,
Gal403

Thanks for the reply. Do I understand your reply correctly, a Userform TextBox cannot receive a numeric value?

Are you suggesting my inquiry should be worded differently?

Hell xlbizniss,

Thank you for the reply and I apologizes it's taken me over a month to get to you. I created a sample userform and appliedSAMPLE 1.xlsm your VBA code but I appear to get an error that I can't locate. Can you assist?

Gal403SAMPLE 1.xlsmSAMPLE 1.xlsm

Sorry for not proofing my last post. Too many redundant errors. Let me try again:

Hello xlbizniss,

Thank you for the reply and I apologizes it's taken me over a month to get to you. I created a sample userform and applied your VBA code but I appear to get an error that I can't locate. Can you assist?

SAMPLE 1.xlsm

Gal403

Thank you. I'll give it a try.