Userform Selections

[niteshift]

2 Option Buttons
1) - Male (optMale)
2) - Female (optFemale)

1 DropMenu w/ 4 entries
1)MLGC
2)BHE
3)BHW
4)EMD

2 more option Buttons
1)FN (optFrontNine)
2)BN (optBackNine)

Now based on the selection there are other values that I need.

For Example the user Chooses "MLGC, Male, FN"
This is associated with Rating = "34.9" Slope = "118"
these are different based on the selections a user makes.

Now My Question (I think) is how do I associate these numbers with the
possible selections???

 

[Jim Rech]

This is associated with Rating = "34.9" Slope = "118"

Whatever procedure you used to determine the above would have to be
programmed in code. Since none of us know what your procedure was it's
quite hard for us to code it. If calculations are involved your code would
have to do those calculations. If table lookups are involved the code would
have to do them...

--
Jim Rech
Excel MVP
|2 Option Buttons
| 1) - Male (optMale)
| 2) - Female (optFemale)
|
| 1 DropMenu w/ 4 entries
| 1)MLGC
| 2)BHE
| 3)BHW
| 4)EMD
|
| 2 more option Buttons
| 1)FN (optFrontNine)
| 2)BN (optBackNine)
|
| Now based on the selection there are other values that I need.
|
| For Example the user Chooses "MLGC, Male, FN"
| This is associated with Rating = "34.9" Slope = "118"
| these are different based on the selections a user makes.
|
| Now My Question (I think) is how do I associate these numbers with the
| possible selections???
|
|
| ---
| Message posted
|

 

[niteshift]

These Numbers are based on the USGA Course Rating and Slope Ratin
Lookup

http://www.usga.org/handicap/CRSlookup/Index.asp

These number never really change and are just associated with what Gol
Course, Gender and which Nine you play.

I need these number to calculate a reference number based on a scor
input the final formula is (Score-Rating)*113/Slope.

I guess I could put them in a table but wanted to keep everything i
the code and just have the result displayed in a users worksheet

 

[Jim Rech]

You sure you don't want to just send users to this site? You'd have to get
their tables and put them in a worksheet, as a first step.

--
Jim Rech
Excel MVP
| These Numbers are based on the USGA Course Rating and Slope Rating
| Lookup
|
| http://www.usga.org/handicap/CRSlookup/Index.asp
|
| These number never really change and are just associated with what Golf
| Course, Gender and which Nine you play.
|
| I need these number to calculate a reference number based on a score
| input the final formula is (Score-Rating)*113/Slope.
|
| I guess I could put them in a table but wanted to keep everything in
| the code and just have the result displayed in a users worksheet.
|
|
| ---
| Message posted
|