I'm using a Userform to collect 4 fields of data e.g. name,date,priority and date finished. I'm then inserting the data into row 7, A7 to D7. I want the userform to ask the user if any more entries are required and if so bring the userform up again but this time insert the data into row 8 and so forth until the user has finished entering all data.
Can someone help me with the code so the userform collects data, inserts the data in the required row, prompts if any more entries are required, if so clears the userform and asks the user to enter details and insert in the next row until the user has no further entries to make and then closes the userform.
Hope someone can understand and help!
thanks
Matt
Can someone help me with the code so the userform collects data, inserts the data in the required row, prompts if any more entries are required, if so clears the userform and asks the user to enter details and insert in the next row until the user has no further entries to make and then closes the userform.
Hope someone can understand and help!
thanks
Matt