+ Reply to Thread
Results 1 to 2 of 2

how to make the webcontent fit the form

  1. #1
    Registered User
    Join Date
    10-13-2012
    Location
    newcastle
    MS-Off Ver
    Excel 2007
    Posts
    68

    how to make the webcontent fit the form

    Hello.

    I have a simple code so that i can use the internet within vba. The webbrowser itself is embedded on the spreadsheet.

    The code to call the website is,

    Sub net()
    Private Sub CommandButton1_Click()

    Sheet1.WebBrowser1.Navigate (Sheet1.Range("b1"))
    Do
    DoEvents
    Loop Until Sheet1.WebBrowser1.ReadyState = READYSTATE_COMPLETE

    End Sub


    Where b1 is the url

    I have a fixed sized window, however when i bring back the website it only partially fits the form.

    How would i resize the web content to fit the size of the window automatically? Essentially like a phone does


    End Sub

  2. #2
    Registered User
    Join Date
    10-13-2012
    Location
    newcastle
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: how to make the webcontent fit the form

    No responses? Is this possible?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to make form fullscreen
    By herukuncahyono in forum Access Programming / VBA / Macros
    Replies: 8
    Last Post: 03-31-2009, 09:09 PM
  2. Can i make Search through Form?
    By L_ter in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2009, 05:37 AM
  3. How do you make a form
    By yorkshirekid in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-28-2008, 07:52 PM
  4. [SOLVED] How to make Form Modeless
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2006, 07:45 AM
  5. [SOLVED] how can I make a form number change everytime the form is opened
    By babydumplingspita in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2005, 03:05 PM

Tags for this Thread

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