Calculating text boxes in VBA

[Pam]

I have a user form that I have made for our sales team to enter orders into.
I have gotten everything done on it but calculating fields. I've no idea
where to start on this, and would love some guidance.
For example I want to take "TxtItemQty1" x "TxtItemUnit1" and put the
results in "TxtItemExt1"
I would also like to know how to format the text boxes, so they line up with
a decimal tab, is this possible in a vba form?
Thanks for any help you can give me.

 

[John Guin]

to clarify - you expect numeric values to be in the original text boxes? You
will then perform a multiplication operation on them, and display the result
in a third box. Right?

Which application are you using for this? Word, Outlook, Excel, something
else?

 

[Pam]

Hello John,
I guess I'm thinking that the VBA form that I built can act like an Excel
Spreadsheet and calculate 1x2=2, am I totally off base on this?
I am using just the VBA form, then when I click save (command button) it
transfers to an excel spreadsheet, but eventually I want it to dump into my
Access database.
Thanks
Pam