![]() |
Multiply a range by Input Box Value
I would like to Enter a value in an input box and then it multiplies
column B by that value. Thanks in advance |
Multiply a range by Input Box Value
Hello,
davesexcel has two example codes that shows how to do this with a loop and then a faster way, using Evaluate. The evaluate code has been very usefull for me, especially when I want to manipulate 30K rows. The results are almost instant, while the looping code takes several seconds. Check it out here http://www.davesexcel.com/vbacodes.htm#724367015 |
Multiply a range by Input Box Value
WOW!,
Thanks alot for the quick reply. I just copied and pasted the code then attached it to a button and it worked flawlessly. |
All times are GMT +1. The time now is 04:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com