+ Reply to Thread
Results 1 to 6 of 6

Setting Destination In VBA

  1. #1
    Registered User
    Join Date
    05-25-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Cool Setting Destination In VBA

    Hi guys

    Love excel and VBA programming. Ive built a Web Browser in A VBA Userform as a pet project and i was wondering,
    I have a button in the top right hand corner that opens a second userform.
    However what i want to do is set this second userform with quick links for a barebone interface unless this is clicked.

    However everytime I click it link, it says object is required because I cant seem to point it to the object on the other userform.

    What is the code i need to input to se the destination as the WebBrowser Userform

    Is it "Dim As "Userform"" ?

    S
    Last edited by Filee360; 05-26-2013 at 07:12 AM.

  2. #2
    Registered User
    Join Date
    05-25-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Setting Destination In VBA

    Anyone at all have any idea?

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    I think you need to explain exactly what you have.

    What 'links' are on the bare bones interface?

    Are they URLs that you want you pass to the webbrowser form and then have that form navigate to them?

    Also, what code have you tried and where does it give the 'object required' error?
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    05-25-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Setting Destination In VBA

    Quote Originally Posted by Norie View Post
    I think you need to explain exactly what you have.

    What 'links' are on the bare bones interface?

    Are they URLs that you want you pass to the webbrowser form and then have that form navigate to them?

    Also, what code have you tried and where does it give the 'object required' error?
    I sorted it by setting the code as follows.

    In place of

    Please Login or Register  to view this content.
    Ive put;

    Please Login or Register  to view this content.
    Realweb being the Userform Reference / Name
    WebBrowser being the Object
    Navigate being the Required Action

    The issue was pointing the desired actions towards the object i wanted to perform these actions.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Why not use FollowHyperlink?

  6. #6
    Registered User
    Join Date
    05-25-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Setting Destination In VBA

    See thats the beauty of VBA, you can do it in various ways ^__^

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1