LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro does not work if form protected Wanna Learn Excel Discussion (Misc queries) 2 August 6th 08 06:07 PM
Excel Form Format to Spreadsheet Format Karen Excel Discussion (Misc queries) 4 October 23rd 06 06:03 PM
Work Underneath a User form peekbo Excel Programming 2 May 20th 04 11:46 PM
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work No Name Excel Programming 0 May 3rd 04 12:22 PM
Form.Refresh doesn't work...help !! Tereba[_2_] Excel Programming 2 January 31st 04 10:43 PM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"