Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOPS
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOPS
Henry wrote:
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 You mean, the "Item1TextBox.Value" is what help to update.. well, that was my mistake, I don't thing I use that type of programming. I'm home now, i try tomorrow... thanks Henry Fernando |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loops???? | Excel Worksheet Functions | |||
Loops | Excel Discussion (Misc queries) | |||
Loops... | Excel Discussion (Misc queries) | |||
do loops | Excel Worksheet Functions | |||
Using For - Next Loops in VB | New Users to Excel |