ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiply a range by Input Box Value (https://www.excelbanter.com/excel-programming/444414-multiply-range-input-box-value.html)

Lane[_3_]

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

Paul Morgan

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

Lane[_3_]

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