View Single Post
  #8   Spotlight this post!  
Unread 10-01-2007, 13:50
Spider-Man's Avatar
Spider-Man Spider-Man is offline
Curling Rocks
AKA: Adam Jacobson
FRC #0467 (DTB/Shrewsbury Colonials); #0034 (Rocket City Robotics)
Team Role: Mentor
 
Join Date: Dec 2006
Rookie Year: 2000
Location: Shrewsbury, MA USA
Posts: 86
Spider-Man has a spectacular aura aboutSpider-Man has a spectacular aura about
Re: paper: Rack & Roll Scoring Spreadsheet v1.0

I was playing with v1.0 yesterday fixing it to work for me and adding extras.

Reset was something i was looking into, and this is the macro I came up with:

Code:
Sub Button1456_Click()

Range("B2:Q2,B9:Q9,B16:Q16").Select
Selection.Value = 6
Range("R3:T3,R11:T11").Select
Selection.Value = 1
Range("A1").Select

End Sub
It selects the the Radio buttons and changes the value to "NADA" for the spider legs and changes the value to "<4"" for the raising of the robots.
Reply With Quote