CloudenL
09-22-2011, 09:11 AM
I have a userform that allows my sales person to chose specific products which then show up on a worksheet. I want to now create a userform that will take those products and bring them back to this new userform when a "review" button is pushed so that my sales person can use a check box to delete from the original worksheet or add in a percentage to calculate volumes.
1. can i have the active list (which can be different depending on the customer) of products come over into individual text boxes within the userform. or is it better to have 1 text box for all the products. i need the checkbox and the percentage boxes to be in line with the products.
2. can i use the checkbox to delete products off the spreadsheet that the products were placed on in the original userform that allowed them to be chosen.
3. can i have a textbox show as a percentage when a number is inputted?
i have lots of questions and am trying to learn, so please bear with me :)
1. can i have the active list (which can be different depending on the customer) of products come over into individual text boxes within the userform. or is it better to have 1 text box for all the products. i need the checkbox and the percentage boxes to be in line with the products.
2. can i use the checkbox to delete products off the spreadsheet that the products were placed on in the original userform that allowed them to be chosen.
3. can i have a textbox show as a percentage when a number is inputted?
i have lots of questions and am trying to learn, so please bear with me :)