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
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