The VBA code I am working on is currently updating six different Data Tables on one Worksheet in one go - it removes password protection, calculates the first Data Table, hardcodes the values and moves on to the next one, then locks it all again and says thank you.
The aim is to have a macro that would separate the six parts of the code dealing with individual Data Tables in such a way that it only updates those Data Tables selected by user, whilst retaining a single code and having the whole process activated by the single ToggleButton. Or should it be CommandButton? Or a MessageBox, where clicking on the OK would trigger the code? If so, how do I get the checkboxes in there?
Apart from writing the actual code, I have created a UserForm and inserted six CheckBoxes and a single ToggleButton, but got stuck at how to handle this further. How do I activate/disable parts of the code based on the boxes checked?
Aucun commentaire:
Enregistrer un commentaire