error in activecell.offset when i open userform

**ncaravela** · 05-07-2010, 09:43 AM

Hi,

I've created a userform but i can't make it work. I'm having 2 dificulties.

First - I'm inserted date in the format "dd-mm-yyyy" but it migrates to the worksheet "mm-dd-yyyy"

Second - When i Run macro in the VBA menu, it works well, but if i close the VBA and open the userform form the selection button i get a run time erro '1004' in this line of code:

Please Login or Register  to view this content.

ActiveCell.Value = txtprospect.Value

Please Login or Register  to view this content.

I send the form in attach to see if anyone can help me.

Thanks

**romperstomper** · 05-07-2010, 10:15 AM

You need to use CDate when writing the dates to the worksheet. I get no error using the form.

**ncaravela** · 05-07-2010, 10:46 AM

I'm sorry, but i don't understand.

Do you mean that instead of using:

Please Login or Register  to view this content.

txtdataregisto = Format(Date, "dd-mm-yyyy")

Please Login or Register  to view this content.

I should use:

Please Login or Register  to view this content.

txtdataregisto = Format(CDate("dd-mm-yyyy"))

Please Login or Register  to view this content.

I've tryed and i get a Run Time Error '13' Type mismatch

**romperstomper** · 05-07-2010, 10:54 AM

No, I mean that when you send it to the worksheet, you should use CDate(txtdataregisto)

**ncaravela** · 05-07-2010, 11:56 AM

Ok,

I can't seam to make it work, i'm not sure where or how to use it, this is only the second time i use VBA, but i won't bother you anymore.

This wasn't the first time that you reply my posts and i apreciate it

Thanks. Have a nice weekend