Calling a function without assigning it to a variable cause an error.

**gvag** · 10-26-2013, 07:46 AM

I have a function I tested with this procedure

Please Login or Register  to view this content.

which worked just fine. But this test for another function gives a compile error

Please Login or Register  to view this content.

unless I revise the call to

Please Login or Register  to view this content.

I appreciate it if someone could tell me why the second test is causing an error.

Thanks

**millz** · 10-26-2013, 07:50 AM

Try changing to :

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**gvag** · 10-26-2013, 03:16 PM

Thanks for the reply but I'd like to understand why the first test works and the second test fails. As I said in my OP assigning the function to a variable fixes the problem.

**mikerickson** · 10-26-2013, 03:23 PM

What is the code for SetFillColor.
I notice that the first bit of code is passing one argument to the routine, while the second bit of code is passing two arguments.

**gvag** · 10-27-2013, 04:40 AM

I'm including both functions, they are very similar.

Please Login or Register  to view this content.

And here's the one that Excel won't compile without the assignment.

Please Login or Register  to view this content.

Apart from understanding why the first test works and the second fails I've decided that the second function should return a boolean value signaling success or failure. If it fails it may be possible to recover from it. (Its part of a bookkeeping application for my daughter and it should work as expected.)

Its been a long time since I programmed in Excel and its a fairly steep re-learning curve, if you have the time I would like to know what the problem is.

Thanks for your time.

**Norie** · 10-27-2013, 07:06 AM

It's is a syntax thing.

If you are returning a value from a function then you need the parentheses.

If you are calling a function but not returning a value you have 2 options.

Please Login or Register  to view this content.

If you wanted to return a boolean value indicating success/failure you could try something like this.

Please Login or Register  to view this content.

**gvag** · 10-27-2013, 04:12 PM

If you look at the start of the thread you will see that my question is not about how to call and return a value from a function, but why the second call shown causes a compile error and the first does not.

Thanks

**gvag** · 10-27-2013, 04:54 PM

If I can figure out how to do it, I'm going to mark this thread as solved. As a test I changed the function and the unassigned call worked.

Please Login or Register  to view this content.

First I tried changing the procedure to a subroutine but Excel still insisted that I assign the call. Changed the function requirements to one parameter and Excel was happy. Still don't know why Excel insists on assigning the call if there's more than one parameter, but at least I know what was causing the error.

Thanks to all who responded. Now if I could just figure out how to mark this thread as [SOLVED]...

**romperstomper** · 10-27-2013, 05:00 PM

You appeared to overlook the answer you were given.

In VBA, you only use parentheses when calling a function if you use the Call statement or you use the returned value. Otherwise you should not use parentheses even if you only have one argument - although it will generally work with data types, it will fail if you need to pass an object type, such as a Range or Worksheet.

**gvag** · 10-28-2013, 01:19 AM

romperstomper
Obviously, there more to it than your post indicates.

Please Login or Register  to view this content.

Ran just fine.

Now if someone would be so kind as to tell me how to mark a thread as [SOLVED].

**romperstomper** · 10-28-2013, 02:13 AM

You are not passing an object there because you didn't use Set:

Please Login or Register  to view this content.

**gvag** · 10-28-2013, 05:15 AM

OK, thanks.

**Fotis1991** · 10-28-2013, 05:20 AM

Originally Posted by gvag

Now if someone would be so kind as to tell me how to mark a thread as [SOLVED].

Please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Calling a function without assigning it to a variable cause an error.

LinkBack

Thread Tools

Rate This Thread

Display

Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Re: Calling a function without assigning it to a variable cause an error.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Problem with calling another macro (Error 450 and " Expected variable or procedure")

[SOLVED] Compile error when calling function in sub

Syntax Error calling StDev Function

Assigning variable values using the Evaluate() function

calling function with variable amount of results

Bookmarks

Bookmarks

Posting Permissions