Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey all, still quite a newbie here.
I need to create something that calculates values entered into input boxes and displays them in a msgbox. This is what I have so far: Sub standard1() fconc = InputBox("Enter final conc.") fvol = InputBox("Enter final volume") sconc = InputBox("Enter conc. of standard") MsgBox = "fconc*fvol/sconc" End Sub Of course I ge an error at the msgbox line because I don't know what I'm doing, but that is the formula I need..fconc x fvol / sconc. Any help would be greatly appreciated. Thanks, Lost. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to input value | Excel Discussion (Misc queries) | |||
input box = formula bar | Excel Discussion (Misc queries) | |||
Using different lines in an input- or msgbox | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
MsgBox and User Input | Excel Programming |