Use object as variable for function

Question

I'm trying to create a function called wait that would use an object:

Function wait(browser As Object)
            ' loop until the page finishes loading
            Do While browser.READYSTATE <> 4
            Loop
End Function

I also have:

Function GetIE() As Object
  On Error Resume Next
  Set GetIE = CreateObject("InternetExplorer.Application")
End Function

and:

Dim appIE As Object
Set appIE = GetIE


sURL = "http://google.com"

wait (appIE)

But i'm getting "Run time error '424'; Object required. Any idea?

Community · Accepted Answer · 2017-05-23 10:31:44Z

2

Change this line

wait (appIE)

to

wait appIE

Explanation: In VBA, whenever you call a Function that has parameters, if you are not doing anything with the return value, then you have to call it without the parenthesis. In this case, since the code is not returning anything, it should be defined as a Sub and not a Function. The same thing applies to Sub routines that take parameters also, i.e. you have to call it without parenthesis with the parameters separated by comma.

Further Reading (via @doug) : Quick VBA Tip: Parentheses

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Nov 26, 2013 at 17:53

Shiva

21.1k15 gold badges88 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Adam Voga Over a year ago

The GetIE function is working properly, the error was thrown when i have added the wait function

Shiva Over a year ago

@AdamVoga Agreed. I just tested your code in Excel and located the problem. See my updated answer above.

Rob Over a year ago

why do the brackets make a difference? Is it something to do with 'making a copy'?

Shiva Over a year ago

@AdamVoga Just updated answer with explanation so others can also benefit from it.

Doug Glancy Over a year ago

+1, for even more about this, read this DDOE post,

|

Collectives™ on Stack Overflow

Use object as variable for function

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related