Userform with URL/hyperlink

M

magix

I would like to create a userform with achieve the following

Let say from Column A1 to A3, I have
A1: FB1234
A2: GV4556
A3: DC2323

In my userform, i have 2 Edit boxes and One button
EditBox1: will have fix url entry, "http://www.something.com/id?="
Button1: will read the value in A1 (let say the activecell is A1), and
append it in EditBox1 after "=", to make it as
http://www.something.com/id?=FB1234 and send it out to read from web server.

The result of web output (which is actually a XML output) will display in
EditBox2 (maybe not editbox, but listbox, whichever can hold multiple lines
of text).

is this workable ?

Regards,
magix
 
Top