Writing UserForm ListBox values to worksheet

  • I'm doing my first UserForm and I have a Submit button on the form for users to click which should then write the data from the various list boxes to the worksheet. I've adapted the code from a textbook example so I thought I'd be ok, but where I want it to start writing the data from the first empty cell in column H and go across, it's dropping the data into cell A2, B2 etc. - overwriting existing data in the worksheet.

    Can anyone tell me where I'm going wrong please?


  • Re: Writing UserForm ListBox values to worksheet

    Ah of course, I'd started counting from H because that was my range but Excel was counting from A.
    That's sorted it, many thanks!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!