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

date: Sun, 23 Mar 2008 08:24:20 GMT   author:   unknown

Re: User Form   

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)



 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

date: Mon, 24 Mar 2008 10:04:17 -0000   author:   Bob Phillips