grizzla
09-19-2008, 03:38 AM
Using vba in Excel 2007
Hi,
I have a userform where the user can define the quantity of a product that is to be made, i already have a worksheet setup that contains the column headings. When the user clicks the OK button i would like the value entered in the quantity textbox to be the number of rows that are populated with numbers 001-the value in Qty.Text.
I have had a search about and cant seem to find anything that would help me do this, if someone knows where i can find an answer please point me in the right direction.
Thankyou
Hi,
I have a userform where the user can define the quantity of a product that is to be made, i already have a worksheet setup that contains the column headings. When the user clicks the OK button i would like the value entered in the quantity textbox to be the number of rows that are populated with numbers 001-the value in Qty.Text.
I have had a search about and cant seem to find anything that would help me do this, if someone knows where i can find an answer please point me in the right direction.
Thankyou