Baisc Macro knowledge

[Evilbob333]

Hi,

I only have a very basic knowledge of working with Macros and Excel so hopefully the question i'm going to ask will be relatively simple for someone to answer.

I'm creating a monitoring system for work and i'm trying to get a macro to tie in alongside a drop down menu. By this i mean that the drop down menu will give several options, i.e. the names of four seperate companies. I want to be able to select one of these companies from the drop down and then when i click on the 'submit' button i wish to be taken to that companies worksheet in the same workbook. So dependent on which company is selected i want to visit one of four worksheets by clicking the same button.

I hope this is clear...please help if you can, it will be much appreciated!

Cheers

[royUK]

What kind of drop down are you using? You could use hyperlinks instead of VBA.

[Evilbob333]

I created the drop down by going through Data toolbar> Validation> List.

I have absolutely no idea how to use VBA either so i'm kinda blagging it!

Cheers

[Evilbob333]

'Please read forum rules below. Titles like


Code:
- some assistance please!
Are not permitted

VBA Noob'

Sorry i'm a newbie...wont happen again.

[royUK]

Assuming that your Data Validation list is in A1 then add this code to the WorkSheet_Change event

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address <> "$A$1" Then Exit Sub
Dim sSht As String
sSht = Cells(1, 1).Value
MsgBox sSht
Worksheets(sSht).Activate
End Sub

To see how to enter the code see this:

http://www.excel-it.com/Forum/viewtopic.php?t=11