Making basic Username and Password in Excel VB (Visual Basic)?

Question

I've been using VB for not so long and I am making a basic username and password test for a program I am going to make in the future, but I can't quite get the coding to work.

Look this is how my interface looks like:

http://i14.tinypic.com/497tg02.jpg & http://i14.tinypic.com/486ehxz.jpg

This is my code:

http://i14.tinypic.com/49iyqrq.jpg

And this is what happens when I click Login:

http://i13.tinypic.com/2vhx5qp.jpg

While what I want to happen is the yellow bar goes green and says Hello.

Please help me. Thanks in advance.

I put the if statement in front, but then this error message came up:

http://i13.tinypic.com/34fi7nk.jpg

What am I doing wrong, please could someone explain in more detail and in simpler terms.

Thanks so much.

Thanks idefix for the help. I have entered your code but unfortunatelly it still doesn't work, I think its getting closer and it is almost working this is what happens:

http://i13.tinypic.com/2nhmicp.jpg

Any more help will be appreciated :-)

My email is [e-mail] or just post here.

Thanks again.

Answer 1

You are missing the "If" command at the beginning of your subroutine.
Start like this: If textusername.value etc.

Also I notice a lot of subroutines you started but did not complete, remove them as they only clutter your code and slow down the execution.

Answer 2

1. "IF" command always starts with "IF" and finishes with "END IF"
2. A user form needs to be updated to show the modification such as "Hello" and a green bar
(Note the code Me is used to avoid repeating the name of a user form. In your case Me = UserForm1

Herewith is what your code should be

Private sub cmdlogin_click()
IF txtusername.Value="texas1" AND txtpassword.Value="Kitty" Then

With Me.Label1
.Caption = "Hello"
.BackColor = &HFF00&
End With

Else

With Me.Label1
.Caption = "Goodbye"
.BackColor = &HFF&
End With

End If
Me.Repaint 'update userform1
End Sub

Answer 3

we additionally make project in VB, it is likewise our project yet our instructor informed as that we could deactivate the settings of the VB and set as default. it quite is kinda complicated to locate the placing decision in simple terms locate it. it been 3 years as quickly as we use the VB. i cant bear in recommendations something of it. im from phil.