Help hiding 5 different shapes with same button

[colonel179]

Hello,

I am trying to hide several shapes with the same button. Those shapes represent the number of cards that are available when selecting a day of the month.

Let's say for the sake of example and simplicity, that i have a button to open a form to schedule an event. One person selects August 20th and picks "BANANA", then another person also selects August 20th and picks "APPLE", and yet another person selects August 20th and picks "ORANGE".

As you can see, three people selected the date August 20th. So when i go to the calendar and select the cell with August 20th, three shapes appear indicating what corresponds to each one (in this case, BANANA, APPLE, ORANGE - one for each shape, since each is an aactual event).

I can make the Three cards appear (up to five). If there are five, I make five appear, if there is only one event then just one card appears.


But what I would like, is that when I select August 20th and there are three events (BANANA, APPLE, ORANGE), instead of the three shapes appearing at the same time, I would like to have a NEXT button. So I created a shape as a triangle to make it look like a next button). With this setup, I can only toggle between only two shapes, but not up to five.

I get the information from an INDEX into a table. let's say that it looks for the date in the table that feeds from the userform, and it gives me let's say in A1 BANANA, then in A2 APPLE, and in A3, ORANGE. If only one event is that date, it only fills A1, or if there are 5 events, it fills A1, A2, A3, A4, A5.

With this logic, I assumed it could be as simple as just hide the shapes depending on the cells A1:A5 being blank or not. If I have three events, then A1, A2, A3, will NOT be blank, but A4 and A5 will.

But the problem is that it only obeys to ONE instruction, and it doesn't cycle between the shapes! i want to have Shape1 show, then click the "next" button and hide Shape1 and show Shape2, then hide Shape2 and show Shape3, and cycle or just hide the next button.

TL:DR
I would just like to be able to hide an show shapes cycling between each other with the same button (shape1 hides, shape2 shows, then shape2 hides, shape3 shows, shape3 hides, shape4 shows, etc.)

Thank you very much!

I appreaciate all your time and support!

[AlphaFrog]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.