PDA

View Full Version : Search data within the spreadsheet to log



marreco
07-02-2011, 06:58 AM
Good day!

I have in my spreadsheet "Home," ten to two buttons (active X), and txtUser txAcesso.

A enter the User and the other to enter the password.

I happen to like that checked into a spreadsheet (could be the "Home"), if the username and password are correct.

How do I?

Thank you !!!!!!!!!!

shrivallabha
07-03-2011, 05:36 AM
I did not understand your question completely. But probably something like:
Private Sub CommandButton1_Click()
If TextBox1.Value = "Username" And TextBox2.Value = "Password" Then
Sheets("Home").Activate
End If
End Sub


I am thinking that you have not hidden "Home" Sheet. If that is the case then it will be:
Sheets("Home").Visible = True