Quote:
Originally Posted by Basel A
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
