Home > Software engineering >  With vba to realize the check box is added in the cell, and lock in this cell (such as the differenc
With vba to realize the check box is added in the cell, and lock in this cell (such as the differenc

Time:09-22

If inscribe
In addition, the value of the checkbox is also associated with the cell

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

If is Excel, unit can multi-select/batch operation, can also copy/paste, with a CheckBox is hard to achieve perfect linkage,
Suggest to switch to a built-in drop-down list, use the data validity \ Settings, choose sequence, source to fill the /,?
  •  Tags:  
  • VBA
  • Related