Thank you again for your help Bob, your solutions are really going t
help me out. Like I stated earlier, Im a novice programmer, I have no
programmed in 2-3 years and my boss came to me with this project whic
was a little over my head, but I knew it was possible.

I have just one last question. You showed me how to return data fro
the worksheet to a label. I just want to be sure I also know how to d
this to a text box.

_For_lablel:__
userfrm.lblSSNCaption = Worksheets("Sheet1").Range("A1").Value
_For_Textbox?_
userfrm.txtSSNvalue = worksheet("sheet1).range("a1").value

???'s
Can I pull the data right from thw worksheet stright into the objec
like this, or do I have to go from the worksheet to a variable and the
to the object in the userform?


Thank you again.

Mike
Kalamazoo, Michiga

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27226