I have a dialog box that I want to use with several employees to clock in and
out with, I need to know how to get an edit box to reference a cell where
the employee password would be stored. All it will give me for options are
Edit validation which I would use the option of "Number" for the password,
(Last four of SSN). It also gives me an option for password edit which hides
the numbers with astrisks. I cant find a way to get the cell that the
password is stored in to be referenced

any help would be appreciated
Thanks

By dialog box do you mean Userform? And by edit box do you mean Textbox? If
so, you can set the ControlSource property of the textbox to link it to a
particular cell.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

justaguyfromky wrote:
I have a dialog box that I want to use with several employees to
clock in and out with, I need to know how to get an edit box to
reference a cell where the employee password would be stored. All it
will give me for options are Edit validation which I would use the
option of "Number" for the password, (Last four of SSN). It also
gives me an option for password edit which hides the numbers with
astrisks. I cant find a way to get the cell that the password is
stored in to be referenced

any help would be appreciated
Thanks