Hi,
I believe the code supplied below is what you require.
I have a worksheet database where i send out parcels to customers & once parcel is received i like to make a note of the date on my database.
I have a drop down list on my userform which looks at the worksheet & loads any customers name...