Get Date from CalendarForm to Multiple Cells

Hello there,

I have a CalendarForm and i have created a button that gets me the day from the selected date to the cell ("J6")

I want to know if theres a way to get the month as well but to a diferent cell , like ("I3")

I have this code but it opens two instances of the CalendarForm.

Please Login or Register  to view this content.

Any help is apreciated

Melo

Try this way:

Please Login or Register  to view this content.

it wroks great, but returns the value of the number of the Month, instead of the name.

If i try to formate with "mmmm" it wont change the name.

any tip?

nevermind, i got it.

Revomed the month

Please Login or Register  to view this content.

and formated the cell with "MMMM"

thanks for the help.

Originally Posted by Tpleme

... but returns the value of the number of the Month, instead of the name ...

e.g.:

Please Login or Register  to view this content.