Hyperlink function not working in VBA

[zakthemaster]

Function Link(gccode)
Link = (URL Begining) & VBAProject.Module1.Gcid(gccode)
End Function

Function Gcloglink(gccode)
Gcloglink = Application.WorksheetFunction.Hyperlink(VBAProject.Module1.Link(gccode), "Log GC" & UCase(gccode))
End Function

Here is the end part of my code.
My code only has functions being made
the first function works.
The second function results in "#VALUE!" when i type it into a cell.
I want it where when I type "=Gcloglink(A1)" into a cell it will give me the same results as when I type "=HYPERLINK(Link(A1),"Log GC"&UPPER(A1)) into a cell (including the ability to click on the cell and be taken to the webpage.)

 

[DonkeyOte]

You can't use a Function to insert a Formula into the calling cell I'm afraid.

(see: http://www.vertex42.com/ExcelArticles/user-defined-functions.html)

=HYPERLINK(Link(A1),"Log GC"&UPPER(A1))

is the correct approach
(assuming you need to use the UDF in the first instance of course)

 

[zakthemaster]

I don't need to use a udf at all
I actually first made a spreadsheet using a super long formula but I wanted to make it look nice if someone were to select the cell formula.
I also know that I could just hide my columns.
But I wanted to make it into it's own function so that my target users would understand what it is supposed to be used for if they selected the formula.
Thanks

I guess I will just go without using the vba the way I wanted

On the plus side while converting my formulas to vba I found neater was to make my formula do what I want