Load userform returning variable not defined error (91)

Hot Topic

How to get the date of the next coming Monday?
Unable to create .NET class in VBA
[ADO Excel] How to use ADO retrieve Excel Worksheet name and some information
Word 2003 Includetext XPath
Filling data from one sheet to another (excel)
Powerpoint 2007 textframe.autosize
How do I create and use 3D ranges in Excel-VBA
whats wrong with this code?
Code for end of month activity submission in an activity system
Running script

Microsoft ISV

How to get the filename into the "Insert Picture" dialogue?
VBA code to search and modify in Word
MS Access User Defined Permissions
ComboBox: VBCode to select first item in the list.
How can I store a merge field value as document metadata?
OPC and C#
Highlighting cells within a worksheet
Microsoft Platform Test for ISV Solutions
Configuration Failed: Windows SharePoint Services 3.0 (Beta)
Power-on 1, Start 2, Keep 3

Load userform returning variable not defined error (91)

Hi there,

I haven't previously had any problems loading/hiding etc userforms in vba, but I've just finished a project that runs fine when stepped through. However, when run properly, it returns a variable not defined error on the Load xForm command. The form is in the same templateproject and the load form command is the first to be executed.

Any ideas

Thanks in advance

Answer this question

Load userform returning variable not defined error (91)

  • Dietz

    This code runs on the form's initialize event:

    frmWeb.WebBrowser1.Navigate ("http://wokiisp.net/index_res.asp")

    frmWeb.WebBrowser1.Document.all("ServiceID").Value = 71

    WebBrowser1.Document.all("ServiceID").FireEvent ("onchange")
    While WebBrowser1.Busy

    DoEvents

    Wend

    frmWeb.WebBrowser1.Document.all("feedID").Value = 343
    WebBrowser1.Document.all("feedID").FireEvent ("onchange")
    While WebBrowser1.Busy

    DoEvents

    Wend

    The 'onchange' event in each case reveals further items on the webpage. All I can think of is that for some reason processing the 'onchange' event does not trigger the webbbrowser1.busy loop so objects further down the line are not loaded before the code attempts to manipulate them when it is run rather than stepped through. If so, is there any other way I can pause the code whilst the webpage updates

    Thanks once again in advance

  • Raj127799

    Thank you!

  • Luis Esteban Valencia Muñoz

    Could you post the code that executes when the form loads



  • Load userform returning variable not defined error (91)
Answer this question