I just browse through other threads and just know that in UserForm:

Range.Copy method doesn't Work from Userform

This is a very disappointing news for me as it is a must request for users to select a category from the combox box and a new row is copied to the worksheet with the value of the category...