Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a button that is used to make several calculations using a value from
a textbox (tbxQuantity) in my UserForm. This value could be used 10 to 100 times in one procedure. I was wondering what would be the most efficient way of writng my equations. When I mean efficient I mean speed. Which is more efficient? Sub Calculate() Dim Qty as Integer Qty = Val(tbxQuantity) Price = Cost * MarkUp * Qty End Sub or Sub Calculate() Price = Cost * MarkUp * Val(tbxQuantity) End Sub Thanks in Advance! -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
More Efficient IF | Excel Programming | |||
What is more efficient | Excel Discussion (Misc queries) | |||
Is there a more efficient way to do this? | Excel Programming | |||
More efficient way? | Excel Programming | |||
Which is more efficient? | Excel Programming |