Computing.Net > Forums > Programming > excel vba for hyperlinks

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

excel vba for hyperlinks

Reply to Message Icon

Name: deadpet
Date: February 13, 2008 at 14:06:19 Pacific
OS: xp
CPU/Ram: n
Product: n
Comment:

I am trying to set up an excel sheet which sets up client databases. Each sheet is a client so I want a main sheet to set each one up and I click and jump to their sheet.
The followng text fails me.....HELP?

Sub Macro1()
Dim asa As String
asa = InputBox("Enter name:")
Sheets.Add.Name = asa
abba = Sheets("main").Cells(1, 9)
Sheets(asa).Move Before:=Sheets(3)
Sheets("main").Select
Cells(abba, 1).Select
Dim hiu As String
hiu = abba & "!A1"
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
hiu, TextToDisplay:=asa
Sheets("main").Cells(1, 9) = Sheets("main").Cells(1, 9) + 1
End Sub




Sponsored Link
Ads by Google

Response Number 1
Name: Razor2.3
Date: February 13, 2008 at 20:35:27 Pacific
Reply:

abba = Sheets("main").Cells(1, 9) <-- I have no idea what you're attempting.

Cells(abba, 1).Select <-- Ditto.


0

Response Number 2
Name: deadpet
Date: February 14, 2008 at 03:16:48 Pacific
Reply:

the first line is getting the row number for next new client and the other selects it to put in hyperlink...


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: excel vba for hyperlinks

excel vba macro assistance www.computing.net/answers/programming/excel-vba-macro-assistance/10837.html

Excel VBA Problem saving file www.computing.net/answers/programming/excel-vba-problem-saving-file-/14722.html

can't open references in vba www.computing.net/answers/programming/cant-open-references-in-vba/19860.html