My "adding a load of variables" idea seems to be not such a great idea, man what was I thinking....
OK...
I have RoomNames that need values like CFMS, Grills, and Boots.
I have one Form with these 3 boxes (text and combo) to input the information from each room. So whether I am entering data for Kitchen or Bedroom1 the same form loads to input the data. That form loads whenever a Checkbox is clicked TRUE.
On my main UserForm there are no checkboxes. They are all created at runtime.
In the Activate Event of my UserForm VBA is creating Checkboxes for each roomname in one of my 5 Tables(Bed, Bath, Living, Recreation, and OPEN). Whenever the Checkboxes are clicked TRUE, then a form to input data such as CFM, Grills, and Boots Activates and waits for input.
So every room in all five Tables is used to create a Checkbox on a particular Page. But only the rooms clicked TRUE will activate the Room Data Userform.
I need each newly created CheckBox to have it's own Variable.