User Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jambun@bigpond.com - 23 Mar 2008 09:24 GMT

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

Reply to this Message

Bob Phillips - 24 Mar 2008 11:04 GMT

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

Signature

---
HTH

Bob

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

> Hi I have made a spreadsheet to calculate golf scores and do
> countbacks, not knowing much about vba programming I am wondering if a
[quoted text clipped - 5 lines]
> Thank You
> EPJ

Reply to this Message

Rate this thread: