HI I have a user form which I want the user to enter data into whic
then inputs that data onto a sheet.

What I want to do is the the following.

1. User enters in a record number (Unique) which I would like to ru
an event that as soon as the user exits the textbox field it unhide
the sheet and checks the sheet from range a7 onwards until it finds it


A. if it finds it needs to inform user it exist and then bring up th
data which the user will then be able to amend.

2. or as soon as the user has inputted all the data and says this exis
and shows the existing data and then askes the user if they would lik
to amend it.

I would prefer the 1. however I have no clue where to start

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38610