Forum Discussion
I need someone that know NFL Playoffs Brackets works
I have code on file called 2019 NFL playoffs brackets have vba code. look at picture of 2020 NFL playoffs system first before you look at 2020 NFL playoffs brackets this file need vba codes ...
Thank you. I wounding how I do as vba code
Thanks You
Thanks You
I wouldn't.
a) why use VBA when worksheet functions do the job?
b) how would you 'trigger' the VBA? If you do it on every change on the worksheet you introduce a lot of overhead and if you add a button then that is an extra step
c) you could use 'onchange' and determine what has changed on the sheet and only update that part of the bracket, but that get pretty complicated and you are essentially trying to recreate what Excel already does with worksheet functions
a) why use VBA when worksheet functions do the job?
b) how would you 'trigger' the VBA? If you do it on every change on the worksheet you introduce a lot of overhead and if you add a button then that is an extra step
c) you could use 'onchange' and determine what has changed on the sheet and only update that part of the bracket, but that get pretty complicated and you are essentially trying to recreate what Excel already does with worksheet functions
- every time I put in the score
Thanks You