Thanks Leith Ross,
I will go a little more into depth on what I want to do.
Worksheet name: "Product Database"
List 1: "Choose Category"
Cell location: B6
Original source: J2:J12
List 2: "Choose Product"
Cell location: E6
Original Source: L11
This is what I want to do when the the ActiveX button "Update" is pressed, but I do not know how to translate it all into VBA code:
- If(data in cell location B6 for list 1 is = cell J2 or "Choose Category", the validation source will be modified to cell L2)
- If(data in cell location B6 for list 1 is = cell J3 or "Bulk Products", the validation source will be modified to cell L2:L7)
- If(data in cell location B6 for list 1 is = cell J3 or "Bulk Products", the validation source will be modified to cell M2:M4)
etc...
I am not sure how I would integrate the code you gave me into everything:
Would I use;
or...
or something completely different?
I really appreciate your prompt help, Leith!
Thanks again,
Shawn
Bookmarks