excel function

[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....

 

[Biff]

Hi Trey!

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

Biff

 

[TREY]

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

 

[Biff]

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