anthonymedz
Board Regular
- Joined
- Jan 30, 2015
- Messages
- 69
Hi Guys,
Please help me on my project. I am creating an inventory/monitoring form that I have a multiple checkbox on my userform and when when i tick the checkbox1 it will automatically go on that particular sheet.
I made a simple program like this.
Sheets("Apple").Visible = TrueSheets("Apple").Select
But i have a hundreds of product and i dont want to manually input all product in the userform the same program as i created.
I would like to have a master sheet that i will be listing all the product located in 4 columns(4 types/categories).
Please help me.. thanks..
Please help me on my project. I am creating an inventory/monitoring form that I have a multiple checkbox on my userform and when when i tick the checkbox1 it will automatically go on that particular sheet.
I made a simple program like this.
Sheets("Apple").Visible = TrueSheets("Apple").Select
But i have a hundreds of product and i dont want to manually input all product in the userform the same program as i created.
I would like to have a master sheet that i will be listing all the product located in 4 columns(4 types/categories).
Please help me.. thanks..
