Hi,

i have a userform where the user has to put in
- a name in textbox called txt_naam
- a code in a txtbox (txt_code)

futhermore there is a button "OK"

If the button OK is clicked i want to
- check if the boxes are filled. if one of them is not filled, i need to set
the focus back on the first empty box

if the boxes are filled, the code has to be checked in a list Sheets("check")
in range H1:H1000

If the code that is put in the textbox i want to check if the code is in the
list.
- if it is not, i want to quit the application
- if it is, my application can start and i would like cell a1 to be filled
with the txtboxvalue that the user has put in.

Last but not least.
Next time the application is started it should see that there is a code in
cell A1 and skip the login screen completely...

I know it is a lot to ask but i tried and tried and only got error messages...

Please help me get the right code
Pierre


--
Message posted via http://www.officekb.com