Login and Password for user form

[royanimesh]

Hi all
i am shearing my problem for some help. i am uploading my sample workbook. it contains a user form. two information is appended here. what i want that, as multiple users can use this shared workbook,
1. the person has to login with an ID and password.
2. in the 3rd column of the excel sheet the ID of the person will appear. it will help in detecting who actually input the data.
3. in addition to Higher Secondary, College and Graduate School, there will be another tab named "other" in Education Level. on selecting "other" a textbox will popup and one can write anything.

i look forward for a help.

thanks

[mohanvijay]

Instead of shared workbook,You may use access database as back end and excel as a front end

[royanimesh]

hi mohan
thanks for replying.:friends: :friends:
i had gone through the idea that access has a limitation of storing capacity. can you pl tell me how much access can store if it is used as back end. further i want another help. i want to include a field named "date of birth". i want the text box in the form to format that it will appear as "__/__/____. can it be done in excel userform?
regards

[mohanvijay]

In Theory Access Database size is limited to 2GB
google it for know more about Access Limitations

In Userform "textbox control" we can't set mask "__/__/_____"
you may validate date by following code



S_Date = Trim(txt_box.Text)
If IsDate(S_Date) = False Then
MsgBox "Enter date in textbox"
Exit Sub
End If
'Check the entered date as your format
'for example if you want enter date as "dd-mmm-yyyy"
If UCase(Format(S_Date, "dd-mmm-yyyy")) <> UCase(S_Date) Then
'Tell user to enter the date in your format"
MsgBox "Please enter date in ""dd-mmm-yyyy"" format"
Exit Sub
End If