Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2003
I am developing a userform in Excel using MS Visual Basic I would like to be able to have a form text box (?) perform a calculation using numbers entered in previous fields, show the result of that calculation immediately for visual confirmation and then enter that result in the proper field in the database. Example... enter the following into form fields: Contract Cost: (enter no.) Hard Costs: (enter no.) Mark Up: (enter no.) Gross Margin %: (formula; based on Markup/Contract Cost) (View this data immediately on the form and then upon submitting form entering calculation in GM% column with this project. Also are there any limitations as to how many fields I can enter onto a custom userform? Thanks for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Interaction of form controls and pictures in Excel 2007 | Excel Worksheet Functions | |||
to find change and paste existing values/rows in excel with help of form | Excel Discussion (Misc queries) | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
Excel Form link to e-mail | New Users to Excel | |||
View of Excel form is different on different computers. | Excel Discussion (Misc queries) |