Is there a way to click a cell and a dropdown list of numbers (0 to 9) pops up to select the digits that make up the number to be entered?
Thanks in advance.
Is there a way to click a cell and a dropdown list of numbers (0 to 9) pops up to select the digits that make up the number to be entered?
Thanks in advance.
Click the cell where you want a drop down list --> Data --> Data Validation --> Allow List --> Type 0,1,2,3,4,5,6,7,8,9 in the Source box --> OK
You can copy the cell down as far as needed.
Does that help?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks sktneer. Could you tell me how to enter the number 2561
Is it a single number 2561 or four numbers 2,5,6,1? What is your requirement actually?
A SINGLE number (2561)
Last edited by Michael6; 07-01-2014 at 09:29 AM.
Hi,
maybe try quick VBA code:
Book1.xlsm
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Thanks Miroslav,
Could you please explain to me how to do it? I mean this quick VBA code!
I an not quite familiar with VBA
Hi,
there are lets say 2stages:
1) worksheet event on 'Sheet1' with 'Userform1' pop-up
2) 'Listbox1' change event with write values procedure
@1
in other words, anytime You click single cell (Target.Count = 1) and this cell is in range B2:G13, 'Start' procedure is triggered with variable 'Target', which is the range(cell):Please Login or Register to view this content.
@2Please Login or Register to view this content.
when You click any digit in listbox, 'WriteVals' procedure is triggered:Please Login or Register to view this content.
in other words, take the value that is already in clicked cell and add the on-userform-clicked digitPlease Login or Register to view this content.
Note that variable 'rRng' is public due to its visibility and scope:
Is it understandable for You?HTML Code:
Thanks again Miroslav.
It is not readily understood as my knowledge in VBA is rather poor. You gave me the idea and I will try and find a way to apply it.
But I still wonder if there is another way other than the VBA !!!
I appreciate your help
Maybe if You share the purpose,someone will be able to find the way how to fulfill Your requirement.
Could any body help me modify the VBA code (suggested by Miroslav) so that a number with decimals in it (eg. 2561.27) can be entered?
Thanks in advance.
Yes,
Book1.xlsm
why not just use the on screen keyboard from accessibility options?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Miroslav, great to see you back.
The modification does not seem to work. Trying to enter, say 253.17 for example, I get 25317
One more thing, can I have the title Amount shown on top?
Thank you very much.
Thank you Martin.
The on-screen keyboard is not what is actually required.
Could you please have a look at the VBA code given above and see if any modification can be made to get to work. Miroslav does not seem to be around at the moment.
Your help will be much appreciated.
The coma (,) that appears in the userform is a mistake, as it should be a dot (.) , that is a decimal point.
I don't Know how to correct this.
Could any one please use the link above [given by Miroslav] and help me out?
Thank you.
Michael
Last edited by Michael6; 07-17-2014 at 06:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks