Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro does not work if form protected | Excel Discussion (Misc queries) | |||
Excel Form Format to Spreadsheet Format | Excel Discussion (Misc queries) | |||
Work Underneath a User form | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming | |||
Form.Refresh doesn't work...help !! | Excel Programming |