Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiply a range by -1 | Excel Programming | |||
Multiply selected cell by a input form | Excel Programming | |||
Multiply a range | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Multiply range | Excel Programming |