| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum formula in a form
Hey all,
I need your expert help. I have created a form (with all of your wonderful help of coarse) anyways, when the user types in a pallet # I would like a label to diplay the remaining boxes available on the pallet. It would need to look in the database and perform a sumif function. Any advice? Thank you! -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum formula in a form
totally guessing, but something like
lblPallet.Caption = Format(Application.Sumif(rngA,txtPallet.Text,rngB) ,"#.##0") -- HTH RP (remove nothere from the email address if mailing direct) "Jennifer" wrote in message ... Hey all, I need your expert help. I have created a form (with all of your wonderful help of coarse) anyways, when the user types in a pallet # I would like a label to diplay the remaining boxes available on the pallet. It would need to look in the database and perform a sumif function. Any advice? Thank you! -- Though daily learning, I LOVE EXCEL! Jennifer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
| cells show formula like in formula bar, rather than result of form | Excel Discussion (Misc queries) | |||
| HELP with formula in an HR form | Excel Worksheet Functions | |||
| Formula for Order Form | Excel Discussion (Misc queries) | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Linear Mode
