How To Hide And Unhide Sheets In Excel With VBA

In this post I’m going to show you how to hide and unhide sheets in excel with vba. We are also going to load
the data from the active sheet into the text boxes of the UserForm.

Essentially, we have 5 worksheets with the same layout. It’s just that each patient has their own spreadsheet.

Then we will load all of the data on the selected worksheet into the text boxes. The UserForm is launched in the previous image.

Here is the code to load all the worksheets:

When a worksheet is selected in the combobox, and “Go” is clicked, the textboxes are filled in, and the other sheets are hidden (take a look at the code)

This is what happens when “Ana Trujillo” is selected:

Let me know if you have any questions.

Use this form to send me a message:

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.
 

Please remember to subscribe to my youtube channel

Been helped? Get these!

Facebooktwittergoogle_plusredditpinterestlinkedinmail