hello everyone I am using excel 2003 and would like some vba code on opening several websites in new tabs for internet explorer. I have the following code.

Sub urltabs ()
const navopeninnewtab = &H800
set tabby = createobject ("internetexplorer.application")
tabby.visible = true
tabby.navigate "http://www.google.com"
tabby.navigate "http://www.yahoo.com", clng(navopeninnewtab)
tabby.navigate "http://www.msn.com", clng(navopeninnewtab
end sub

everything works great with this code but I want the user to be able to put the urls in cells rather than change them in the vba editor how can I accomplish this?

You can use an InputBox, but you'll need to add code that validates whatever the user inputs.

StrHlink = InputBox("What is the URL to use?" & vbcr & _
"e.g: http://www.google.com","Navigation Input")
'validation code goe here
tabby.navigate StrHlink

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]