Run function

  • Thread starter Thread starter Abrm
  • Start date Start date
A

Abrm

Hello,
I made a function, this function returns a value that i would like to put in
a certain cell.

In a cell you can put for example =now() then the field is filled with the
date and time.
If I do this with my function, just write in a cell "=begindate()", the
cell returns #NAME?.
How can I solve this?
 
The function should be in a standard module, not in a sheet module.
Alt-F11 to go to the VB Editor
Insert>Module
enter your function
Alt-F11 to return to the worksheet

If you still have problems, post your function
--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
| I made a function, this function returns a value that i would like to put in
| a certain cell.
|
| In a cell you can put for example =now() then the field is filled with the
| date and time.
| If I do this with my function, just write in a cell "=begindate()", the
| cell returns #NAME?.
| How can I solve this?
|
 
That works, thanks a lot.

And if you want to run a function from startup of a sheet, or refresh(f9) of
the page.
Is there an event you can use?
 
Back
Top