Hi Dennis,
I feel your pain. If you decide to get back into it, you'll probably do
better posting questions on the [email protected] message list.
tc
Dennis Marks wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
