How Do I Tell My Userform Which Range of Cells To Update?

Hi,

I have been playing about with Excel spreadsheets this week and I have made just a basic sheet to collate some data. I also would like a user form to update the data from one place.

I have a form made with a text box and label for each of my 7 columns and it works OK. The problem is that my sheet has a range of data cells - B5:H50. I also have some text in the columns to the right of my data range for information.

So, my userform initially finds the next empty cell at A13. A is the first column but it only acts as a left border. 13 is the row below my text to the right hand side.

Data is only inserted by the form from A13 onwards and I would like to tell my form to only update data within my range - B5:H50. My code is shown below from a basic example I found online.

Can anybody help please?

Thanks
Stuart

----------------------------------------

Please Login or Register  to view this content.