I am producing a tablet friendly version of a excel spreadsheet. I have many data validation tables (click down and select). I have series of cells where only one value ("1") is needed. I was wondering if there is an option where a value can be defaulted to a cell on a click only. So that if a clicked (or even double clicked), a value of "1" will automatically populate that cell. I understand excel will not run macros on tablets. Thank you for your help.
Bob
Excel will run macros on tables. Properly written, you could likely use the Worksheet_SelectionChange event to do what you want. But I don't want to tackle it tonight. Maybe tomorrow if nobody else jumps in.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
This assume the range to receive the value of '1' is in column A. You can change the code to the range you want the procedure to apply to. For example, if you want to use B10:C20 then change 'Range("A:A") in thise line:to Range("B10:C20")
Please Login or Register to view this content.
The ranges are worksheet ranges and not table ranges. To use the macro, copy and paste it into the sheet code module for the worksheet where you want it to apply. Once installed, you can click in the cells you want the 1 to appear in and it will automatically populate the cell. To remove the 1 from the cell, click in the cell, then press the Delete key.Please Login or Register to view this content.
Last edited by JLGWhiz; 05-27-2020 at 10:02 AM.
Thank you so much for your time JLGWhiz. I couldn't get this to work. Attached is this copy. I am obviously doing something wrong.
You need to put the code into the sheet1(Bet Finder) module.
However it work on an android tablet, if that's what you want.
Ok. Thanks for that Fluff13.
I don’t think VBA works on any mobile device.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks AliGW. I just found that out. Back to the drawing board.
So, VBA won't run on tablets. However it would be great is I could get it to work on my laptop. I need to enter "1" columns I:P. To streamline this process I was hoping to click in the cell for a 1 to be entered. Still not working on laptop. I apologise for my incompetence.
Delete the two modules that you have added & then follow the instructions in post#5.
@AliGW
Not something I've ever tried & could well be wrong, but I think you can use VBA on windows devices.
I can’t find anything online, even on MS sites, that says anything other than the mobile version of Excel does not support VBA. Happy to be proved wrong ...
I'm probably the one's that wrong, just thought I'd seen something that said windows based tablets could run VBA. Maybe I'm just going mad, having been cooped up at home for 68 days & counting
Well, we’ve all been in lock-down, so we are probably all mad by now.
From Disney's adaptation of one of my favorite books: https://www.youtube.com/watch?v=hTLOlf5My6wWell, we’ve all been in lock-down, so we are probably all mad by now.
Now, back to your regularly scheduled programming.
Originally Posted by shg
It did not take COVID-19 to make me nuts! I just realized that the OP said tablets, not tables.
Last edited by JLGWhiz; 05-27-2020 at 08:22 PM.
@Fluff13 & @AliGW - Just for info:
https://www.excelforum.com/the-water...d-tablets.html
Yes, that’s for full Windows 10, so the device would need to be running Excel proper, not the mobile version. Thanks,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks