Chris Webb
New Member
- Joined
- Oct 25, 2002
- Messages
- 1
Hi all,
I'm making a paint formulation spreadsheet. The user chooses ingredients and quantities, then specific weight, price etc are calculated. Its mostly working fine, using Vlookup. The problem comes in simplifying the way the user enters names of ingredients.
The ingredients are in two "tiers", i.e the group Solvents contains items Water, Texanol, White Spirit etc., the group Thickeners contains items SCMC,
HPMC, Acrysol etc., the group Extenders contains items China Clay, Talc,
Ropaque etc.
I'd like the user to be able to:
1) click on a command bar (or menu or whatever) -the Groups list appears..
2) click on a Group name -the items in that Group appear.
3) click on the chosen item -its name is pasted in.
I can do it with data validation, but only as one enormous list or using 2 columns.
I've failed to do it in custom lists and by creating a custom menu. I'm not smart enought to do it in visual basic without some pointers.
Can anyone help?
I'm making a paint formulation spreadsheet. The user chooses ingredients and quantities, then specific weight, price etc are calculated. Its mostly working fine, using Vlookup. The problem comes in simplifying the way the user enters names of ingredients.
The ingredients are in two "tiers", i.e the group Solvents contains items Water, Texanol, White Spirit etc., the group Thickeners contains items SCMC,
HPMC, Acrysol etc., the group Extenders contains items China Clay, Talc,
Ropaque etc.
I'd like the user to be able to:
1) click on a command bar (or menu or whatever) -the Groups list appears..
2) click on a Group name -the items in that Group appear.
3) click on the chosen item -its name is pasted in.
I can do it with data validation, but only as one enormous list or using 2 columns.
I've failed to do it in custom lists and by creating a custom menu. I'm not smart enought to do it in visual basic without some pointers.
Can anyone help?