Control Toolbox , user paths

[penzer]

COuld anyone tell me how to do this and what to use to do it:

I need to have a function where by the user has to input something or select something in order to get to a different page etc.

I want the user to have to select or input something in order to acess the hyperlink which opens a powerpoint presentation.


please Help,

thanks in advance

[Richard Buttrey]

COuld anyone tell me how to do this and what to use to do it:

I need to have a function where by the user has to input something or select something in order to get to a different page etc.

I want the user to have to select or input something in order to acess the hyperlink which opens a powerpoint presentation.


please Help,

thanks in advance

Hi,

You could name the cell which contains the hyperlink, say "Hyperlink", then ask the user to use the Edit-->Goto menu, select the name Hyperlink and OK.

Alternatively you could attach a CTRL Key, say CTRL-H which runs a simple line of VBA macro code, e.g.

Sub ViewHyperlink
Range("Hyperlink").Parent.Activate: Range("Hyperlink").Select
End Sub

HTH

[penzer]

cheers for your help. how would i go about getting a hyperlink to load if the user was to select/click a button (not just a macro ) i mean the button in the control toolbox (radio button it might be called) the singular button

thanks

[mudraker]

hexaflexagon

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

[Richard Buttrey]

cheers for your help. how would i go about getting a hyperlink to load if the user was to select/click a button (not just a macro ) i mean the button in the control toolbox (radio button it might be called) the singular button

thanks

Hi,

You'll need to write a one line piece of code (or macro) and attach it to the button. Personally I'd use the square button from the Forms toolbar rather than the radio button which is usually used within a frame for selecting one of several options. Don't forget you can attach macro code to any object. It doesn't have to be a forms control object. It could be an icon, or even a picture graphic taken from the hyperlink site you want to get to.

Anyway, whichever you use, here's the code:

Sub MyHyperlink()
    ActiveWorkbook.FollowHyperlink Address:="http://www.excelforum.com/newreply.php?do=newreply&p=1879811", _
        NewWindow:=True

End Sub

HTH

[penzer]

cheers for your help