run a macro from a value in a cell

[AndyD]

hi there
I have an index formula in a cell, so for example it could return "macro1" or "macro2".

What vba do i need do runs the macro mentioned in the cell?

Cheers

Andy

 

[danial]

Put below code to your vba page (your sheet which contain there index)

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.SubAddress = "" Then Run (Target.Name)
End Sub

this way work when you set the index to hyperlink
you can use below code to set your index to hyperlink
if you index kept in column "A"

For K = 1 To [A1].End(xlDown).Row
ActiveSheet.Hyperlinks.Add cells(K,1), "", "", , cells(K,1).Value
Next

 

[AndyD]

Hi Thanks for your reply

its actually a little bit different to this...i dont want a macro to automatically run when the value in the cell is changed.

I want users to press a "create report" button that does something first (macro_part_1) then runs the macro in the cell for part 2

Hope makes sense?
Cheers
Andy

 

[danial]

Is this code as you want?

For K = 1 To [A1].End(xlDown).Row 
Run cells(K,1)
Next

 

[AndyD]

great thanks very much!