Macro/ vba help - drop down box

**AWS33** · 09-10-2018, 09:10 AM

Hi All

I need so help with macros/ vba.

I’ve created a drop down box, and when something is selected in that box I want it to automatically take the user to another sheet in the
Same spreadsheet. Is there a easy way of doing this?

Thank you for any help in advance,

A

**Mumps1** · 09-10-2018, 09:27 AM

You will need to list the items in the drop down box and the corresponding sheet names for each item. Also, in what cell is the drop down box?

**AWS33** · 09-17-2018, 03:58 PM

I've attached what the spreadsheet looks like.

Basically In Colum 'D' are all the drop down boxes. The lists are in the same sheet. An example is Column 'J'. What I want to do is create a macro that when a activity is selected in column 'D' it will automatically take you to the correctly named sheet in the same spreadsheet that explains the activity in more detail.

Thank you for any help in advance

**Mumps1** · 09-18-2018, 11:16 AM

It looks like the items in the drop down list are the actual sheet names you want to go to. Is this correct? If it is correct, then you don't need the list in column J. Are the drop down lists only in the range "D6:D24" or can this range vary?