Hyperlinks into a userform - help please

[ArmsteR]

How can i extract the hyperlink path from an excel column and get it
pasted into a column in a listbox along with the link title ?

File Page Size


drawing1 A4
drawing2 A3
drawing3 A3
drawing4 A4


To display in the listbox like:


File Page Size link


drawing1 A4 \\server\drawings\drawing1.dwf
drawing2 A3 \\server\drawings\siteinvestigations\drawing2.pdf
drawing3 A3 \\server\drawings\old\drawing3.dwg
drawing4 A4 \\server\drawings\housetype\drawing4.pdf


I hope this makes sense!


I've got nearly every part working of my script to have an inbuilt
batch printing setup on my drawing register files which will be
posted
on here when i finish but this is fairly cruicial.


Thanks
Dave

 

[David McRitchie]

See http://www.mvps.org/dmcritchie/excel/buildtoc.htm#HyperlinkAddress

If not familiar with installing User Defined Functions and Macros
see http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro