I'm not sure exactly how to word what I'm trying to do and what I need in assistance, but here goes.

I have a spreadsheet that I have created a form for that (at present) has a dropdown box (choosing a name), a blank label to be dynamically captioned, and a text box (for the data entry).

What I need:

1. When a name has been selected from the dropdown list, any information in the Notes field for that name is shown in the blank label field.
2. Continuing on from there once data has been entered into the text box for the name selected, the data is entered into the appropriate field.

ie.

Johnson at Range ("A4") is selected from the dropdown.
lblNotes.caption=activecell.offset(0,15).value

Then have:

Activecell.offset(0,12).value=txtMR 'this being the textbox.

Hopefully the is a clear explanation of what I'm trying to do. If it isn't let me know and I shall definitely try to explain it better.

TIA for any and all assistance you can give.

datapard