Thread: LOOPS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Henry[_4_] Henry[_4_] is offline
external usenet poster
 
Posts: 72
Default LOOPS

Fernando,
If you're working in a spreadsheet:
Cell A1 contains quantity, Cell B1 contains Unit Price, Cell C1 =A1*B1
Cell C1 will update each time you change quantity in A1.

If you're working in a UserForm:

Item1TextBox.Value = Quantity1TextBox.Value * UnitPrice1TextBox.Value
Item2TextBox.Value = Quantity2TextBox.Value * UnitPrice2TextBox.Value
Etc.
TotalTextBox.Value = Item1TextBox.Value + Item2TextBox.Value + Etc.


HTH
Henry

"Fernando Duran" wrote in message
...
i Don't have much experience in programming, so, i need some help in
technics to do a few things to work as I want to to behave.
Lets say, that in an invoice, every time the user changes data, for
example Qty. the amounts they have to change a the same time.. How can I
get to that point? looks like a loop..

Thanks

Fernando