Thanks for give me a Hint in the right Direction Paul Hossler.
i have try your Code but it aint Work...
now what i want is the Value been set in Cell area like they other values and Colomn Y been show total Value for But It aint work
Doubleclick on Sheet's "H-erne" in cell Area B3:V130 then Chose a Player and Cupgame then you could enter Value in
textbox for "180" and "Higest" and "No"
the function works for "180" and "Higest" but not for "NO"
the 180 is a Maximum Score with 3 Trown Dart's
the Highest is where to Put a Player's Highest Out score it could be from "2 to 170 "
the "No" is How many Dart's a Player used to get down from start to end normaly game is 501 to 0 where 9 Dart's is the Fastest
these Infor is only to explain my Idea