Forum Discussion

BetaV's avatar
BetaV
Copper Contributor
May 14, 2020

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

Resources