• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Entering a multi digit number in a cell using the mouse.

M

Michael38

New Member
I'm trying to find a way of entering a number (of more than one digit including decimals) in a cell by clicking the target cell and selecting the digits and the decimal point from a dropdown list.
My VBA knowledge is very limited, and I'm looking forward for your help with the appropriate VBA code.
Thanks in advance.
 
Michael38 said:
I'm trying to find a way of entering a number (of more than one digit including decimals) in a cell by clicking the target cell and selecting the digits and the decimal point from a dropdown list.
My VBA knowledge is very limited, and I'm looking forward for your help with the appropriate VBA code.
Thanks in advance.
Click to expand...
Faseeh said:
This might help: http://www.excelforum.com/excel-pro...8647-onscreen-numeric-keypad.html#post2355790
Click to expand...
Thank you Faseeh,
Could you please modify the code given by Martindwilson in Excel Forum (keypad test.xls) so that the keypad includes decimal point "." shown on it for entering decimals, ie. to enter the number 572.14 for example ?
And it will be great if the keypad can have the heading (title) "Amount" on top.
 
Faseeh said:
Hi @Michael38

Please see attached file. @Luke M : Thank you for help :D
Click to expand...
Thanks faseeh, but what is required is that when the user clicks the target cell, the keypad appears, with two buttons on it {"Cancel" (in case a wrong number is selected by mistake), and "OK" for the keypad to disappear once the number is correctly enterd}, in addition to the digits (0 to 9). The two buttons "Add" and "Decimal" are confusing and need to be replaced by one button " . " .
I appreciate your trying to help.
 
Last edited by a moderator:
Dear @Michael38,

Please find attached file, in case it does not fit your requirement, please provide layout of calculator using paint brush etc.
 

Attachments

  • keypad test Final.xls
    65.5 KB · Views: 9
Faseeh said:
Dear @Michael38,

Please find attached file, in case it does not fit your requirement, please provide layout of calculator using paint brush etc.
Click to expand...
Dear Faseeh, my sincere thanks.
The keypad has to appear on clicking the entry cell, not by a command button in a separate cell. That is to say activating a cell (to enter a number in it) should invoke the keypad. And I wonder why the decimal separator "." does not show while typing. It appears only after clicking the OK button. The Cancel button causes the keypad to disappear while it is meant to clear a wrong number entered by mistake, leaving the keypad displayed for entering the correct number to replace the wrong one. The keypad should disappear ONLY after clicking the OK button, and that is what is actually happening alright. So, the word "Clear" is more appropriate than "Cancel". Choosing the inappropriate name for it was my mistake in my previous reply.
I really appreciate your attempt to help.
Thanks again
Regards
Michael
 
You must log in or register to reply here.
Back
Top