Formulae In User Forms
Hi,
I have a user form in a recruitment related business into
which the user inputs the chargeable remuneration of the
candidate e.g £25000 and will then have to select from
several fee options. On entering the chargeable
remuneration, I would like a couple of information boxes
to appear underneath which would say something like
Our standard fee for this assignment is x%(x being a
calculated variable based upon the chargeable remuneration
and contained in a spreadsheet within the same workbook as
the user form)and £y (y=chargeable remuneration multiplied
by x%)
I'd be grateful for any thoughts on the best way to
achieve this.
Thanks
Graham
|