BrianExcel
Well-known Member
- Joined
- Apr 21, 2010
- Messages
- 975
Each row in my spreadsheet contains a different product (Apples, Oranges, Bananas, etc).
The second, third and 4th columns are types of locations (Small, Medium, Large, etc).
What I would LOVE to do is place checkmarks on my userform1. The first will be apples, the second oranges, etc.
When I select a product, I want a grid on my userform showing which locations carry that product.
So when the form opens, it's blank except for three static columns, each of which is a store type.
When I click Apples, a first row is created on the form with "Apples" in the first cell. Then an "X" appears under Medium and Large because those stores carry them, but the small stores doesn't.
Any thoughts on how I could accomplish this?
The second, third and 4th columns are types of locations (Small, Medium, Large, etc).
What I would LOVE to do is place checkmarks on my userform1. The first will be apples, the second oranges, etc.
When I select a product, I want a grid on my userform showing which locations carry that product.
So when the form opens, it's blank except for three static columns, each of which is a store type.
When I click Apples, a first row is created on the form with "Apples" in the first cell. Then an "X" appears under Medium and Large because those stores carry them, but the small stores doesn't.
Any thoughts on how I could accomplish this?