itechxxiv
12-29-2005, 10:25 AM
.:The Scenario:.
I manage all the documents Team Leads create, modify, and distribute. I use an Excel spreadsheet to track & report various
attributes i.e. Doc Started, If it is under review, and so. There about 50 documents to track. The Document data is cultivated from
our online Document Management System.
.:The Rational:.
At some point in the process I manually create a Hyperlink in my spreadsheet for each entry to easily jump to the Doc location
within the online Doc Mgnt system. I am transitioning the WrkSht to be more robust and integrate some automation.
.:The Current State:
I have created a drop down list that allows me to select the
appropriate item based on the Doc status. Then I use Excel?s
?Insert Hyperlink? to apply the URL to ?LINK? item in the list.
Fig.1
http://www.itechxxivexcelvb.metasketch.com/ScreenShot01.jpg
[Items in the List: Link, No Link, No External Doc, NA]
.:The Objective:.
Is to have the ?Insert Hyperlink? Dialog box automatically pop-up when the user selects
?LINK? in the drop down list.
Fig.2
http://www.itechxxivexcelvb.metasketch.com/ScreenShot02.jpg
The drop-down list reside in column R, Cell Range(R9:R65) How can I use VB
to create this feature. Or perhaps bypass this approach and create a Form
that pops-up that the user can paste in the URL.
Thank you for your time and effort.
I?m rather new to VB please try to give me as much detail as you can or in addition,
- Links to How-To?s
- Other Tutorials
itechxxiv
I manage all the documents Team Leads create, modify, and distribute. I use an Excel spreadsheet to track & report various
attributes i.e. Doc Started, If it is under review, and so. There about 50 documents to track. The Document data is cultivated from
our online Document Management System.
.:The Rational:.
At some point in the process I manually create a Hyperlink in my spreadsheet for each entry to easily jump to the Doc location
within the online Doc Mgnt system. I am transitioning the WrkSht to be more robust and integrate some automation.
.:The Current State:
I have created a drop down list that allows me to select the
appropriate item based on the Doc status. Then I use Excel?s
?Insert Hyperlink? to apply the URL to ?LINK? item in the list.
Fig.1
http://www.itechxxivexcelvb.metasketch.com/ScreenShot01.jpg
[Items in the List: Link, No Link, No External Doc, NA]
.:The Objective:.
Is to have the ?Insert Hyperlink? Dialog box automatically pop-up when the user selects
?LINK? in the drop down list.
Fig.2
http://www.itechxxivexcelvb.metasketch.com/ScreenShot02.jpg
The drop-down list reside in column R, Cell Range(R9:R65) How can I use VB
to create this feature. Or perhaps bypass this approach and create a Form
that pops-up that the user can paste in the URL.
Thank you for your time and effort.
I?m rather new to VB please try to give me as much detail as you can or in addition,
- Links to How-To?s
- Other Tutorials
itechxxiv