Solved: Please help tech wizards!

[lbartowski]

I'm hoping one of you tech wizards could help out a newbie with some basic VBA code for a userform. Here's what I have on a user form. I'm getting an error message.

2 Labels:
1. Please enter your first name:
2. Please enter the year you were born:

then click OK

after they click OK I need for a "lblOut" to read: "You are -- years old"

Then I would like to give them a line that says "correct?" with a yes or no option.

If yes then "Yippee!" Else "Your B-day must be coming up!"


THIS IS OVER MY HEAD! Any help is appreciated.

[Paul_Hossler]

Can you post the workbook?

Paul

[lbartowski]

Here's the workbook. Thanks.

[Tinbendr]

[vba]Private Sub CommandButton1_Click()
Dim vName, vYear
vName = txtName.Text
vYear = txtYear.Text
lblOut.Caption = vName & ", you're " & Val(2010 - vYear) & " years old."
End Sub[/vba]

[lbartowski]

Thanks Again

[lbartowski]

Thanks guys

[Tinbendr]

Change the name of your userform.

Rename it to MyUserForm.