mukhtarhope
03-31-2018, 02:28 AM
Dear Forum Members,
I need a little help with an userform with fewer boxes
I am trying to create an inventory.
I sell yarns (clothes for school children)
I have 11 categories of Yarn Listed Alphabets "A" to "K".
Each Category has 20 colours.
So we have combinations of 11 categories x 20 colours = 220 combinations
Each Yarm comes in Roll form (So how many Rolls sold or bought)
Each Roll has a weight in Kgs.Gms (Kilograms)
Price at which bought or sold
Amount = Weight x Price (not Roll into Price)
In Each Category, 20 boxes for Rolls for each colour, 20 boxes for Weight of each colour, 20 boxes for Price for each colour, 20 boxes for Total Amount for each colour (Weight x Price)
(Roll, Weight, Price, Amount) 20 x 4=80 Text boxes in Each Category
Therefore for 11 Categories, it is 880 Textboxes
This for the Purchase section
Again the same type for the Sales section
So the number of Textboxes for input increases to 880 x 2 = 1760
I tried making Userform with codes, but when I reach halfway Excel crashes and says, overcrossing 64k, or out of memory reduce data, or says Procedure to long.
How should I reduce the number of Textboxes and codes or somebody shows me a designed userform on how I can overcome it.
The category is A to K
The colours are 1 to 20
Waiting for help,
Regards,
Mukhtarhope
I need a little help with an userform with fewer boxes
I am trying to create an inventory.
I sell yarns (clothes for school children)
I have 11 categories of Yarn Listed Alphabets "A" to "K".
Each Category has 20 colours.
So we have combinations of 11 categories x 20 colours = 220 combinations
Each Yarm comes in Roll form (So how many Rolls sold or bought)
Each Roll has a weight in Kgs.Gms (Kilograms)
Price at which bought or sold
Amount = Weight x Price (not Roll into Price)
In Each Category, 20 boxes for Rolls for each colour, 20 boxes for Weight of each colour, 20 boxes for Price for each colour, 20 boxes for Total Amount for each colour (Weight x Price)
(Roll, Weight, Price, Amount) 20 x 4=80 Text boxes in Each Category
Therefore for 11 Categories, it is 880 Textboxes
This for the Purchase section
Again the same type for the Sales section
So the number of Textboxes for input increases to 880 x 2 = 1760
I tried making Userform with codes, but when I reach halfway Excel crashes and says, overcrossing 64k, or out of memory reduce data, or says Procedure to long.
How should I reduce the number of Textboxes and codes or somebody shows me a designed userform on how I can overcome it.
The category is A to K
The colours are 1 to 20
Waiting for help,
Regards,
Mukhtarhope