Multiply a range by Input Box Value

  • Thread starter Thread starter Lane
  • Start date Start date
L

Lane

I would like to Enter a value in an input box and then it multiplies
column B by that value.

Thanks in advance
 
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
 
WOW!,
Thanks alot for the quick reply.
I just copied and pasted the code then attached it to a button and it
worked flawlessly.
 
Back
Top