I've designed a simple userform in Excel VBA to insert new records into a
worksheet. It works fine, however there are a couple of things I would like
to do with it:


1) I would like it to report back in a message box the value of another
cell, say the A2, where the userform inserts data into B2 thro' to D2, with
A2 made up of a concatenation of B2 and C2 (to make up a ref Nos).

2) I would like the userform to be able to edit previous entries by clicking
on the previous or next button, or searching on one of the data entry fields,
say A2 - the ref Nos.

Can you help.

Tom