Forum Discussion
BetaV
May 14, 2020Copper Contributor
Capture Current Cell contents to insert into a URL
I log ham radio calls in Excel. I have a list of ham callsigns that I wish to validate by looking them up online at https://QRZ.com/lookup/<callsign>
such as:https://qrz.com/lookup/kj7bih
This website returns a brief summary of the ham radio operator including their name and address if it's on file along with a picture.
How do I capture the callsign just entered in the current cell and insert it into the URL and then at the touch of a button, do the query?
Ideally, I would like the web page returned by this query to appear in a separate Textbox or object in the sheet and not in a separate window.
Thanks
No RepliesBe the first to reply