User Form

Hi I have made a spreadsheet to calculate golf scores and do
countbacks, not knowing much about vba programming I am wondering if a
user form can be used to enter imformation on to the spreadsheet but
also show on the user form the results of what would be entered ie:
If a Golfer had 4 strokes on hole 1 and if entered would receive 2
stableford points, can I get the user form to show this before I
commit the score to the spreadsheet?
Thank You
EPJ

Have another label and in the textbox entry update it

Private Sub TextBox1_AfterUpdate()

With Me

Select Case Val(.TextBox1.Text)

Case 4: .lblPoints.Caption = 2
Case 5: .lblPoints.Caption = 1
'etc.
End Select
End With
End Sub

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



<jambun.TakeThisOut@bigpond.com> wrote in message
news:ld4cu311doko92009itnemdquljoi4mkni@4ax.com...
> Hi I have made a spreadsheet to calculate golf scores and do
> countbacks, not knowing much about vba programming I am wondering if a
> user form can be used to enter imformation on to the spreadsheet but
> also show on the user form the results of what would be entered ie:
> If a Golfer had 4 strokes on hole 1 and if entered would receive 2
> stableford points, can I get the user form to show this before I
> commit the score to the spreadsheet?
> Thank You
> EPJ