I have a requirement for a table of "attendees" to an event, that needs to be hidden except when called for. My thought on this was, "can I embed a Table in a User Form and then access and hide the form upon required use?" I have attached a WB.XLS as a mock up design (simple) to see if it is doable. If not, I'll need other ideas but for now, this seems to be an approach worthy of investigating. You will see that Sheet 1 has the Table. And the UserForm is already identified in the VBA Editor. What I don't know is how to marry the two together.
Any help would be appreciated. Thank you in advance.