Multiple conditions within Worksheet_SelectionChange(ByVal Target As Range)

[brunces]

Hey, guys. What's up?

Please, I need some help from you, experts.

I have 5 sheets and here is what I want to do:

In Sheet1, if I click on A2, it goes to Sheet2. If I click on A3, it goes to Sheet3. If I click on A4, it goes to Sheet4. If I click on A5, it goes to Sheet5.
In Sheet2, if I click on A1, it goes to Sheet1. If I click on A3, it goes to Sheet3. If I click on A4, it goes to Sheet4. If I click on A5, it goes to Sheet5.
In Sheet3, if I click on A1, it goes to Sheet1. If I click on A2, it goes to Sheet2. If I click on A4, it goes to Sheet4. If I click on A5, it goes to Sheet5.
In Sheet4, if I click on A1, it goes to Sheet1. If I click on A2, it goes to Sheet2. If I click on A3, it goes to Sheet3. If I click on A5, it goes to Sheet5.
In Sheet5, if I click on A1, it goes to Sheet1. If I click on A2, it goes to Sheet2. If I click on A3, it goes to Sheet3. If I click on A4, it goes to Sheet4.

As you may have noticed, the cells A1 to A5 work like buttons which lead to other sheets. These cells are big (width and height) with small texts in the middle of them. I could, but I DO NOT want to use hyperlinks, and the reason is very simple: if I use hyperlinks, I will have to click exactly on the TEXT to go to another sheet and this is very annoying. The way I'm trying to do is better because I can click on the cell itself, so even if I don't click on the TEXT of the cell, it will still work.

I've already made this code:

Please Login or Register  to view this content.

This works perfectly, but there is only one condition and I need 4 of them. When I try to add more conditions, it won't work properly, certainly because I'm doing it the wrong way. Here it is:

Please Login or Register  to view this content.

By the way, I'm using macros (mcrGoToSheet#) because it does more things than just activate the sheet in question. Example:

Please Login or Register  to view this content.

So, what do I have to do to have multiple conditions within the Worksheet_SelectionChange event?

I hope you can help me. Thanks a lot for you attention.

brunces

[protonLeah]

Option 1:

Please Login or Register  to view this content.

Option 2:

Please Login or Register  to view this content.

[brunces]

protonLeah,

Thank you very much for your answer.

Although I have understood your point, I still have a doubt.

My first post was just "an example", I mean, what I have here is not really the same. For example, my "buttons" are actually not in sequence, from A1 to A5. I explained my problem like that (A1 to A5) to make it simple. I just couldn't imagine you would use the row of the cell as part of the code (which, by the way, was awesome!). So, I appologize for that. I tried to make it simpler to explain, but that led to a (neat and intelligent) solution that, unfortunately, does not fit my needs exactly.

Here in my sheets, the cells (buttons) are not in sequence. Each button is a random cell. For example:

C3 = Button to go to Sheet2.
C9 = Button to go to Sheet3.
D15:D18 (merged cells) = Button to go to Sheet4.
D27:D29 (merged cells) = Button to go to Sheet5.

Well, that said, what would the code look like? Something like this? :P

Please Login or Register  to view this content.

Once again, I'm sorry. I tried to be simple, but it was not a good idea.

Thanks a lot.

brunces

[protonLeah]

Select Case Target.Address(0, 0)
Without the (0,0), you must use "$" in the Address string like
Case "$C$3"

[brunces]

Very cool! Thank you so much, protonLeah! I really appreciate your attention. Cheers.

[brunces]

Hi, it's me again.

I've run into a situation here... If, for any reason, somebody selects all the cells, the code goes crazy. Is there any way to avoid this kind of issue? I mean, macros must be run only if those specific cells are selected. If I select all the cells (or more cells than those specific ones), nothing should happen. Is that possible?

Thanks, guys.

[Aks2014]

Out of curiosity, why don't you just insert shapes such as rectangles, format them to look like the buttons you desire and assign your macros to them?

[protonLeah]

Check for multiple cells selected:

Please Login or Register  to view this content.

rest of code continues below the check

[brunces]

Wow! That's great, protonLeah. This is new to me. Thank you so much for your help. Cheers.

Just for the record, I had to use it this way...

Please Login or Register  to view this content.

... and it worked perfectly.