dansam
02-22-2007, 09:25 AM
Hi everyone, :hi:
I have a command button and a textbox1 on a user form.
In textbox1 there is a short address of a website like instead of ?Http://www.google.com ?there is only ?google.com? (or instead of ?http://www.vbaexpress.com/portal.php? there is only ?.vbaexpress.com?)
And what I want to do is:
(1) When user clicks on command button, it shows the full address of a website (as I mentioned above) in a msgbox.
(2) It also shows a msgbox which contains the title bar address . Like for google.com the title bar address (which we can found in title bar of internet explorer) is ?Google? which is like ?Google ? Microsoft Internet Explorer?
So,
Is it possible? :think: :think: :think:
And if yes then are there any suggestions for the right vba code that I should use??? :think:
Thanks, :rofl:
Dan
I have a command button and a textbox1 on a user form.
In textbox1 there is a short address of a website like instead of ?Http://www.google.com ?there is only ?google.com? (or instead of ?http://www.vbaexpress.com/portal.php? there is only ?.vbaexpress.com?)
And what I want to do is:
(1) When user clicks on command button, it shows the full address of a website (as I mentioned above) in a msgbox.
(2) It also shows a msgbox which contains the title bar address . Like for google.com the title bar address (which we can found in title bar of internet explorer) is ?Google? which is like ?Google ? Microsoft Internet Explorer?
So,
Is it possible? :think: :think: :think:
And if yes then are there any suggestions for the right vba code that I should use??? :think:
Thanks, :rofl:
Dan