Hi, I need to select from drop down lists that need to be interlinked and
dependent based on the choice made in the preceding list Primary List -
Coal, Gas Renewables Coal List €“ Anthracite, Bituminous, Lignite, Peat
Anthracite List - Hi-grade, Low Grade
Bituminous List €“ Low Volatile, Medium Volatile, High Volatile
Lignite €“ No sub list
Peat - No sub list
Gas List - LPG, CNG, LNG
( No other sub lists)
Renewable List €“ Solar, wind, Hydro, Tidal
Example : If I choose Coal , the next Drop Down List will show the Coal
List. From the Coal List, If I Select €œBituminous€� then the next drop down
list will show the sublist €œLow Volatile, Medium Volatile, High Volatile.
Now if I select €œHigh Volatile€� €“ the cell takes in the string €œHigh
Volatile€� Any help on how to make this happen .

Thanks

See here...

https://www.contextures.com/xlDataVal02.html

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion