troubleshooting Question

A Table within a User Form

Avatar of Bright01
Bright01Flag for United States of America asked on
Microsoft OfficeMicrosoft ExcelVB ScriptVBA
24 Comments2 Solutions7467 ViewsLast Modified:
EE Pros,

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.

Excel VBA Developer
Join our community to see this answer!
Unlock 2 Answers and 24 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros