Dave,

I have taken some pictures, hopefully this will help you understand.

'Member Details form' (http://www.starwithin.co.uk/memberdetails.gif)
'Sheet data' (http://www.starwithin.co.uk/spreadsheet.gif)
'Member List' (http://www.starwithin.co.uk/memberlist.gif)

The member details userform is the first image this is where all the
details for a user is enetered. This is then added to the spreadsheet
"MemberList" which can be seen in the second image. Finally the last
image is the member list which shows all users on the system.

The double click event needs to open the member details form and
populate all the fields in it with the data stored for that record in
the spread sheet image 2.

Does this help.
??

Bach


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=468634