jsrhee
04-25-2005, 11:29 PM
Hello,
I am a newbie to vba so bear with any ignorance.
I am currently creating a userform in Excel. Say, I have 3 textboxes:
1. Price
2. No. of shares
3. Investment (which equals Price * no. of shares)
I am trying to put a formula? or code? in the 3rd textbox that would multiply whatever value a person puts in textbox 1 and textbox 2. I want the calculation to happen as soon as a person inputs data in textbox 1 and textbox 2, and be able to move onto to other fields in the userform.
Any help will be greatly appreciated! Thanks in advance.
I am a newbie to vba so bear with any ignorance.
I am currently creating a userform in Excel. Say, I have 3 textboxes:
1. Price
2. No. of shares
3. Investment (which equals Price * no. of shares)
I am trying to put a formula? or code? in the 3rd textbox that would multiply whatever value a person puts in textbox 1 and textbox 2. I want the calculation to happen as soon as a person inputs data in textbox 1 and textbox 2, and be able to move onto to other fields in the userform.
Any help will be greatly appreciated! Thanks in advance.