Linking a List to a Worksheet

[delts509]

I am working on a custom rubric in Excel. I have several different rubrics as worksheets within the same workbook (software, hardware, accessories, etc.).

The first worksheet a user would see is an informational page that asks for the users information, and has a drop down list (made using data validation) that asks them to select what they wish to view (software, hardware, accessories, etc.).

I am looking for a way to send the user directly to the worksheet based on their selection. For instance, if the user selects "Software" from the drop down menu, they would be taken to the software worksheet.

Is this possible? If so, how would this be accomplished?

Any help is greatly appreciated!!

 

[Roderick_E]

Try worksheet change click on the informational tab, right click view code.

Suppose the dropdown is in A5. The code would look something like

if range("A5")="Software" then
worksheets("Software").activate
endif

And so forth for the other selections

 

[delts509]

Try worksheet change click on the informational tab, right click view code.

Suppose the dropdown is in A5. The code would look something like

if range("A5")="Software" then
worksheets("Software").activate
endif

And so forth for the other selections

So I have to apologize as I am not familiar with where this code would go. Would this be required in the Macro section, or something I could use as the If/Then statements within the formula section.

Thanks again!!

 

[Roderick_E]

This code would go into the Worksheet_change macro. Access it by right clicking on the tab and selecting view macro

 

[delts509]

This code would go into the Worksheet_change macro. Access it by right clicking on the tab and selecting view macro

That worked perfectly for all of the choices!! Thank you so much, I was struggling to find a way to make that happen!

One quick follow-up question. Is there a way to execute the same code if the worksheets were hidden? Currently, they are all visible, but I was hoping to hide them so that the tabs are not selected by the user. When I run the macro with the worksheets hidden, nothing happens.

Thanks again!!

 

[Roderick_E]

Glad it worked. You could add:

if range("A5")="Software" then
[COLOR=#ff0000]worksheets("Software").Visible = True[/COLOR]
worksheets("Software").activate
endif

And to get real fancy, you could hide them all back on close of the workbook

Private Sub Workbook_BeforeClose(Cancel As Boolean)
[COLOR=#FF0000]worksheets("Software").Visible = false
'add more here as needed[/COLOR]
End Sub