I'll try and make this as clear as possible, please feel free to check for clarity though.
Basically i'm building a tool that will allow users to establish the distance between two postal codes.
It works on a very simple basis, simply entering the two postcodes into a hyperlink at the appropriate place. Because of the format of the link, lots of / /'s etc i've had to split it up.
and then add it together:
leaving me with something like this:
=HYPERLINK(B2&B3&B4&B5&B6,"Get Directions")
What i would like to do i use a InputBox (though i guess a textbox inside a userform is going to be the solution) with Two Fields, Start PostCode & End Postcode, upon clicking "Ok" the hyperlink will be created and ideally followed.
In a nutshell i suppose what i need to know is how to extract the answers from an input field and add them to a generic text to form a hyperlink.
Any ideas? Is this possible?
Thanks
Ben
Basically i'm building a tool that will allow users to establish the distance between two postal codes.
It works on a very simple basis, simply entering the two postcodes into a hyperlink at the appropriate place. Because of the format of the link, lots of / /'s etc i've had to split it up.
and then add it together:
leaving me with something like this:
=HYPERLINK(B2&B3&B4&B5&B6,"Get Directions")
What i would like to do i use a InputBox (though i guess a textbox inside a userform is going to be the solution) with Two Fields, Start PostCode & End Postcode, upon clicking "Ok" the hyperlink will be created and ideally followed.
In a nutshell i suppose what i need to know is how to extract the answers from an input field and add them to a generic text to form a hyperlink.
Any ideas? Is this possible?
Thanks
Ben