Wednesday, February 19, 2014
Changing the value in a worksheet text box, Part 2: Purpose Built
Here are the first path mentioned in Changing the value in a worksheet text box, Part 1.
This depends on accessing the values in cells (ranges) and manipulating them for what goes into the .DrawingObject.Caption. The original code establishes where these are because they shift each month. The ranges are hard-coded for this example. B2 is the total number of employees. B1 is the number assigned. Both are end of month snap shots.