View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chad chad is offline
external usenet poster
 
Posts: 273
Default Format() doesn't work from a Form

I have two add-ins that I created for excel 2000. Each add-in uses the
format function to reformat dates, etc. The module from add-in #1 is now
giving me this error:

"Wrong number of arguments or invalid property assignment."

Here is my code that I am running on each module:

sub test()
msgbox format(cdate(date),"mm-dddd-yy")
end sub

(the actual code I'm running is obviously more involved, this is just a test
macro)

On the module for add-in #2 it runs fine, on the other I recieve the error
message. I'm sure it's a simple thing I've overlooked but I'm unable to find
it. I clicked on "Tools" and "References" and they both have the same
references checked off. I'm at a loss.