Selecting a sheet based on a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an worksheet used to input data which includes a drop down list with
subjects, lets say by way of example -types of animal. In other cells you can
input information about the subject from the drop down list. Further sheets
are named that reflect the names in the drop down list

I want to be able to select a worksheet based on the subject from the drop
down list using VBA.

At the moment I can readily select one sheet such as:

Worksheet("tiger").Activate

How do I substitute "tiger" for whatever is chosen on the input worksheet
cell drop down list????

Cheerz

Wilcster
 
Private Sub ListBox1_Click()
Worksheets(ListBox1.Value).Activate
End Sub

Mike F
 
Why not just keep an array of sheet names and look them up in there or
just a select case statement that converts the selection to a sheet name??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Clear a "moving" range offset from Target 31
using a conditional formula from a drop down list and If Statement 8
Drop down list - link to another worksheet 4
User selects existing sheet to paste to 4
Define the Range of a drop-down list 5
how to trigger a validation change 3
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Back
Top