Hey Everyone,
I'm back with another question. I'm trying to use VBA to make it where, when I input numbers, lets say in cell b6:b12, I want those numbers to automatically round to the nearest multiple of 15. I've got lots of formulas through my research, but I have no idea how to specify cells to update. I'm looking to get more information and possible a formula example so that I can get this working correctly.
Any help would be greatly appreciated.
1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Similar approach. But using MRound.
Please Login or Register to view this content.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Thank you both very much for your wisdom! I went with the MROUND method. It's the only one I could figure out how to do multiple ranges with different multipliers. I'm posting how my final code for it turned out.
This gave me exactly what I needed to achieve the desired results. Thank you both again for all the helpPlease Login or Register to view this content.
You can handle the checks that you are doing for Count and Length just once, and instead of Length, use a check for a number, so that you don't have to handle errors thrown by MRound or Round:
Using VBA Round:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 10-05-2019 at 07:50 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks