Hello, I have been working on this small project and I it works to create checkboxes and check what boxes are checked. However, at the end of checking which boxes are checked there is a pop up error message saying Run-Time error '1004':
Unable to get the CheckBoxes property of the Worksheet...
I wonder if anyone can help – I have 2 separate spreadsheets within the same workbook.
Sheet1 contains several rows of basic data.
Sheets2 contains a single row of formulas which calculates based on the first row of data in Sheet1.
Using VB I would like to count the number of populated data...
On May 11th, 2008, 06:38 PM, MrExcelMVP "Fazza" provided an excellent code in response to a request by "gravy679" titled "Match and replace cell from another sheet": http://www.mrexcel.com/forum/showthread.php?t=318911
Application.ScreenUpdating = False
Dim cel As Range