Excel VBA Hyperlink that acts like command button - is it possible? 1

[alwayslrN]

Is it possible in Excel VBA to have something that looks like a hyperlink, but acts like a command button? - I am using Excel 2002.

I've been searching this site and the web, but I must not be using the correct keywords to find what I am looking for.

Thanks

 

[Andrzejek]

Can you use just regular Label on the Form?

Set its color to Blue, and font to Underline, and use _Click event.


Have fun.

---- Andy

 

[SkipVought]

Hi,

"...looks like a hyperlink..."

What does hyperlink have to do with the functionality?

Does this mean that if the TEXT in the cell is formatted as Andy described above, then clicking in that cell will trigger an event, but some other cell that is not so formatted will do nothing when selected?

Are ALL the values in this column so formatted or are thes scattered throughout the sheet in different rows and columns?

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[alwayslrN]

Yes it means take text and when clicked have it do something. No not ALL values in the column are formatted. There would be just be about 5 specific pieces of text that when clicked would perform an action, like when a button is clicked.

 

[SkipVought]

This has NOTHING to do with formatting.

It is the Worksheet_SelectionChange Event.

Right click the sheet tab and select [v]View Code[/b]

In the Sheet Code Window click the Object Drop Down and select Worksheet

In the Sheet Code Window click the Prodecure Drop Down and select SelctionChange

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Not Intersect(Target, Union(Range("A1"), Range("C2"), Range("K5"))) Is Nothing Then
    'do something here...

  end if
End Sub

where A1m C2 & K5 are the specified cells



Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[alwayslrN]

Thanks Skip - that did what I wanted/needed.