Retrieving data from sheet into userform and being able to update(replace) that data

Hello all,

I'm new here and would like to know if you can help me with this.

I"ve created an excel form which feeds an excel sheet with data. This userform has several textboxes.

Every time I create a new entry the userform will populate a new row with the values specified.

I want to create a command button (RETRIEVE) to find a value that has been previously entered in a textbox in the sheet and then auto populate the rest of textboxes with the values of that row.

Once that's been done I want to be able to update (replace) that information with another command button (UPDATE).

Any help would be very appreciated.

Requests.xls

Here is the file.

Thanks in advance.

Is it the DERS Request column that will have the value you want to find?

If it is you could use a combobox instead of a textbox for DERS Request.

The combobox would be populated from the DERS Request column.

When the user selects from the combobox it's ListIndex property can be used to get the row.

If there was some sample data I could demonstrate what I mean.

Well... So far I have no data in this document but if you could just enter dummy info in there that's would be fine. I just need to know how to be able populate all text boxes from the ders request number and then update that information.

I've no idea what sort of data to enter in the worksheet, could you not add some?

Requests2.xls

Here is the file with some data in it. Thanks!

Have a look at the atttached.

By the way, why was the font of all the textboxes set so you couldn't see what was in the textbox?

Took me a while to realise that.

THANK YOU NORIE!!! It worked perfectly! You changed most of my code but I understood yours so it's ok I really thank you for this. Now the next step is generating an initial email and a completion email but I will try to do it myself. Thank you again!

Glad it worked.

I didn't really change your code, I just tidied it up and got rid of a few redundant bits.