VB Code to enter cell content within VB code

[rizmomin]

I am using below code to go to certain website.
In the below code i need to make Address part to be variable.
So assume i have http://www.google.com in cell C4, I need the content of Cell C4 inserted in Address:=
so that i dont have to create seperate Sub for each Website, just need to enter the website address in excel.

Please Login or Register  to view this content.

Please let me know if you have any questions.
Thanks.

Riz

[Logit]

.
Using this code :

Please Login or Register  to view this content.

[rizmomin]

Hello Logit:

There is small misunderstanding.
Rather then having lots of individual code for each web site, i need to have one unique code where code needs to pick up the web address from cell C4,C5,C6 etc....

Please Login or Register  to view this content.

In above address will be pick up from C4 when button at B4 is pressed
If i press Botton at B5 then adreess needs to picked up from cell C5 and so on.
I hope this is clear and let me know if any questions.

Riz

[Logit]

.
Not certain I understand what you seeking.

In the below code i need to make Address part to be variable.

URel is a variable.

You will always have to 'tell' Excel what the URL is. Either as you have it now with a hyperlink in the cell or a line of code in VBA.

Guess you could create a "IF THEN" scenario and reference the command buttons on the sheet.

Something like (NOTE THIS IS NOT THE ACTUAL SYNTAX) :

Please Login or Register  to view this content.

[Logit]

.
Place this code in the Sheet1 VBE :

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.