View Single Post
  #323   Spotlight this post!  
Unread 24-11-2013, 12:19
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,825
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: 2014 Season Long Fantasy FIRST

Quote:
Originally Posted by Basel A View Post
My VBA skills are very limited at best, but you can set up macros to run whenever certain cells are changed, so you can use that to change the format of a cell from time to integer (and to trigger rebuilding the remaining teams list).
You got more knowledge on that than I do--I didn't know you could set 'em up to run on a change. I'll have to set up a format-change macro next (I'm actually planning on setting up a clear function to empty out a draft, but changing format ought to be pretty simple).


BTW, if anybody does decide to look at the macros--be advised, they're kind of a mess, though I *think* I left enough comments to follow what I was doing. When I've got it fully functional, I'll have to go in and try to clean up a little.
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

Reply With Quote