Multiply a range by Input Box Value

[Lane]

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]

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]

WOW!,
Thanks alot for the quick reply.
I just copied and pasted the code then attached it to a button and it
worked flawlessly.