Automatically Open a hyperlink in excel using enter

Flatdown

New Member
Joined
Mar 11, 2009
Messages
1
Hello one and all,

I have a worksheet with various parts on and a hyperlink to a technical drawing which is a pdf file.
Users put a part number into cell D5 and all the relevant other parts are found and listed using index and match formulas.
This will also return the hyperlink to the drawing in cell D6.
What i would like to happen is once they have entered their part number and pressed enter that the drawing opens in another window.
I am using office 2003 other users may use 2007.
I have trawled the internet looking for a solution only i am not that good with vba so other peoples solutions may not make sense to me as i don't know what the code means and cannot change it accordingly.

I apologise if this query has been answered already but as i say i'm not that good with vba so i need my solution spelt out i hope i have been clear in what i am trying to achieve.

Many thanks in advance
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,129,361
Messages
5,635,812
Members
416,884
Latest member
leeshjay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top