although not precisely what you describe, it should give you the basics.

XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749


--
Regards,
Tom Ogilvy


"Chinx21" wrote:

HI! i JUST WANT TO ASK ON HOW TO VIEW DATA FROM A WORKSHEET TO THEIR
CORRESPONDING FIELDS IN THE USER FORM AND DELETE DATA FROM A WORKSHEET USING
FORM AFTER THE USER HAS BEEN ABLE TO FIND FOR A PARTICULAR DATA BY INPUTTING
AN ID NO.
I HOPE YOU CAN HELP ME. THANK YOU!