User Form not updating worksheet

**denise6372** · 04-10-2012, 02:06 AM

Hi
I have created a userform and input code (I'm still very much a trainee in this) and it was happily transferring the data from the userform to the relevant worksheet until i added a column on the worksheet and a linked combo box on the userform and now it doesn't want to transfer the information from the form to the worksheet.

I have attached a non-sensitive copy of my workbook in case i haven't explained myself very well.

On the worksheet named OS there is a button to click to get the userform that I am talking about, and the worksheet where it is meant to be storing the data is called Datastore.

Thanks very much in advance.
Denise

**Paul** · 04-10-2012, 02:17 AM

Hi Denise,

If you walk through the adddata button's click event you'll see that iRow is receiving a value of 14950-ish. There are rows of data starting around 14940, and the macro is adding all data below that.

Delete from row 2 through row 1048000 (whatever the last row is) and it will reset to 2. If you already have data that you need, delete all empty rows then try again.