ListBox/ComboBox Acting as Macro/Hyperlink Tool
Phil,
What are you putting in the LB/CB to indicate the destination ?
Assuming it is filled from a range called "LinkList" that contains all the
hyperlinks, you could:
Range(LinkList).Hyperlinks(List1.Index + 1).Follow....
I don't use hyperlink etc much, but something along these lines should work.
NickHK
"Phil H" wrote in message
...
Hi Nick,
Thanks for your reply - glad to know this is possible.
Using Excel 2003. Can you help me set this up? I want to set up either a
LB or CB, don't know which is preferable, here to move users by macro to
other worksheets within a workbook, or by hyperlink to documents outside
the
document - I need both capabilities in one tool. Below is a typical macro
I'm using to move within the workbook. Can you help me set up this tool
code?
Thanks, Phil
Sub GoToREP003()
Application.ScreenUpdating = False
Sheets("REP003").Select
Application.Goto Reference:=Range("A1"), Scroll:=True
Application.Goto Reference:=Range("A100"), Scroll:=False
ActiveWindow.Zoom = 84
Application.ScreenUpdating = True
End Sub
"NickHK" wrote:
Phil,
You have the _Click and _Change events for these controls where you can
run
whatever code you require.
NickHK
"Phil H" wrote in message
...
Is it possible have a List Box or Combo Box act as a macro and/or
hyperlink
tool, such that when the user highlights one of the choices and clicks
on
it,
the selected text appears in the LB or CB, and the macro or hyperlink
is
executed?
|