I decided it is not worth the trouble to do what I want with my own function. It has been too long since I wrote a basic program. Thank you for your trouble. At least I know how to start if I want to write one in the future.
"Dennis Marks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I noticed that but I still have problems. > > Can I use a standard Calc functions such as date() in the basic function. > It looks like I have to replace ";" with "," or I get an error. My other > problem was using a type of date. The function will actually returns a > number if I can get it to work. > > "Anthony Chilco" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> Hi Dennis, >> User functions don't always update like the built in functions. You may >> have to force a calculation after making a change to the function. >> tc >> >> Dennis Marks wrote: >> >>>Thank you. I'll have to play with it. I tried a modification and I had >>>problems. >>> >>>Function testit (theyear as integer, themonth as integer, theday as >>>integer, theweek as integer) as date >>> testit = date(theyear,themonth,theday) >>>end function >>> >>>First I ran it without "theweek as integer" and a date was returned. >>>I added "theweek as integer" on the function line and got errors. >>>I went back and tried to change the date and it still returned the >>>original date. >>>I tried to use a named cell for theyear and got errors. >>> >>>I think I have a lot to learn. >>> >>>"Anthony Chilco" <[EMAIL PROTECTED]> wrote in message >>>news:[EMAIL PROTECTED] >>> >>>>Hi Dennis, >>>>Yes, you write them as basic functions in the macro editor. I've >>>>attached a spreadsheet with an example. I'm cc'ing your address in case >>>>the file is stripped in the list. >>>>tc >>>> >>>>Dennis Marks wrote: >>>> >>>> >>>>>Is there a way to create my own functions in Calc? There are some date >>>>>and >>>>>time functions that I would like to create. >>>>> >>>>> >>>>> >>>>> >>> >>> >>>-------------------------------------------------------------------------------- >>> >>> >>> >>>>--------------------------------------------------------------------- >>>>To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >>> >>>--------------------------------------------------------------------- >>>To unsubscribe, e-mail: [EMAIL PROTECTED] >>>For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >>> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
