Thread
:
Problem understanding dependant lookups
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
paul
Posts: n/a
Problem understanding dependant lookups
i can email you a forms combo box example.Is that your real email addy?
--
paul
remove nospam for email addy!
" wrote:
I have been reading examples on how to set up dependant lookups but I
am not getting it. I have a table of information the includes pipe OD,
weight, and ID. The is a unique ID (among other things) for each OD and
weight selection.
OD Wt ID
60 10 50
60 20 51
60 30 52
73 20 70
73 30 71
73 40 72
What I would like to do is have a validation list that contains the
possible OD selections, once the OD is selected it would automatically
change the available selections for the weight (Wt) validation list.
Once the OD and wt are selected the ID is displayed. If the OD was
reselected then the wt and ID shoold also be reset.
This looks so easy to do on the surface of things but I am not getting
it.
Thanks for any help.
Reply With Quote