There must be a more elegant way to do this. to all versions of MS Excel (including Excel 97-2003, XP, 2007, 2010, etc.). However, I can't figure out how to automate a vlookup for every individual checkbox and put the data in the appropriate underlying cell. Practice MS Excel MCQs Basic Computer Multiple choice questions (mcqs) with. I found some code on another forum that generates a list of values for each checkbox ( vba - Obtain the value of an HTML Checkbox inserted in Excel worksheet - Stack Overflow).īased on that, I recorded a macro to extract the htmlName of a single checkbox and then set up a Vlookup for the True/False value. I need to do two things with the checkboxes and would like to do a third:ġ: Count how many checkboxes are ticked in each of the columns.Ģ: Compare a column A of checkboxes to a column B containing numbers, and then both count and highlight any row where the checkbox is ticked but column B is a 0.ģ: (optional) I would like to erase the html checkboxes and, if the box was checked, replace it with a regular x in the underlying cell. The data has several columns of html checkboxes. I am copying a large table of data from a report generated in Firefox and pasting it into Excel 2010.
0 Comments
Leave a Reply. |