excel function

  • Thread starter Thread starter trey
  • Start date Start date
T

trey

i have a worksheet that id like to link up to certain
cells with another worksheet... my goal is to have it
where when a choice it made- from a drop down list it
triggers a value from another cell within the same
worksheet... is this possible and how would i do this....
 
Hi Trey!

What does, "it triggers a value from another cell within
the same worksheet" mean?

Biff
 
what i should have said is... i have a form which i want
to link up to rate sheet --im in the mtg business...
where when a loan program is chosen from a list box the
corresponding rate appears in a predefined cell on my
form... i guess ive got a couple of dilemna/s...creating
a list box with all the programs--linking them to the
cell with the rate for that program and then getting both
within the actual form... i hope this make/s sense...
some direction would be greatly appreciated---i can even
email you the workbook to take a look at if that's
possible...
thanks
trey
 
Hi Trey!

What kind of list box are you using? From the Control
Toolbox? If so, you need VBA code to make it work and I
can't help with that. If it's a list box from the Forms
toolbar or a data validation dropdown list I can help.

Biff
 
Back
Top