Hi first time making a userform in Excel.
I plan to use this userform i created on a touchscreen monitor.
What I am doing is a small userform as a rounding to the nearest 5 cents and the subtracting the
money given away from the rounded figure and give my answer in a another textbox.
I have everything working fine using my numeric key's and enter key on my keyboard.
The problem is that I can not get a commandbutton on my userform to work the same as the
enter key on my keyboard.
So i would like for a command button on the touch screen to work the same as an enter key on the keyboard.
example of what i do
I Key in 19.06 in text box 1 (sales Amount) then hit enter key my cursor then skips to text box 3 (Cash Taken)because my calculations
to round the 19.06 to 19.05 is placed in text box 2 (Rounding)
then in text box 3 (Cash Taken) I would key in the amount of money a customer gave me "20.00" to subtract from text box 2 (Rounding) hit enter key
the answer is placed in text box 4 (Change). answer 0.95
I have the numeric button 1 - 0 and a clear button to reset everything for the next customer all working good on the touch screen.
But can not get a button (Enter)to work on the touch screen like the enter key.
So i would like for a command button (Enter)on the touch screen to work the same as an enter key on the keyboard.
I have search the internet and youtube and found help for all my other issue just can not find a solution for this.
Any help would be great. thanks
I plan to use this userform i created on a touchscreen monitor.
What I am doing is a small userform as a rounding to the nearest 5 cents and the subtracting the
money given away from the rounded figure and give my answer in a another textbox.
I have everything working fine using my numeric key's and enter key on my keyboard.
The problem is that I can not get a commandbutton on my userform to work the same as the
enter key on my keyboard.
So i would like for a command button on the touch screen to work the same as an enter key on the keyboard.
example of what i do
I Key in 19.06 in text box 1 (sales Amount) then hit enter key my cursor then skips to text box 3 (Cash Taken)because my calculations
to round the 19.06 to 19.05 is placed in text box 2 (Rounding)
then in text box 3 (Cash Taken) I would key in the amount of money a customer gave me "20.00" to subtract from text box 2 (Rounding) hit enter key
the answer is placed in text box 4 (Change). answer 0.95
I have the numeric button 1 - 0 and a clear button to reset everything for the next customer all working good on the touch screen.
But can not get a button (Enter)to work on the touch screen like the enter key.
So i would like for a command button (Enter)on the touch screen to work the same as an enter key on the keyboard.
I have search the internet and youtube and found help for all my other issue just can not find a solution for this.
Any help would be great. thanks
Last edited by a moderator: