VBA code to contol Form Control checkboxes

Checkboxes are one of the easiest ways to create interaction with users.  Controlling them with VBA makes them more flexible and more useful in Excel applications. Here is a collection of the most common code snippets and settings. Create Check Boxes The following code will create a checkbox Sub CreateCheckBoxes() ‘Create variable Dim chkBox As Read More

3 ways to change or insert images based cell values

From stock parts to holiday villas, from employees to logos, there are plenty of reasons to insert and automatically change an image based on a cell value.  Or you may think if this a formula which changes a picture, rather than a number.  Ultimately, the purpose is to link an image or picture to a Read More