On userform "keyboard"

[MoonAlert]

Hello,

I have a userform with 6 textbox to fill with numeric data.
My goal is to select one textbox and use a "numeric keyboard" (as command buttons) on the userform to fill it.

How can I do it since I don't know what textbox the user will select (there are no mandatory order) and, on other hand, I loose the selection of the text box when user click on one of the "numeric keyboards"?

Thanks for help.

[LJMetzger]

Hi MoonAlert,

You might want to try one of the following:
a. Have Six Option Buttons (in a group) that selects the 'Active' TextBox.
b. Double Click or Right Click on a TextBox to make it the 'Active' TextBox'.

In each case, you might want to disable or hide the other TextBoxes until data entry for the 'Active' 'TextBox' is finished.

Lewis