Problem updating a cell value

Hi all,

I have code which I am trying to use to update a cell with a revised 'date of birth'. The VBA fires on AfterUpdate event of a field called DOB on a userform.

Please Login or Register  to view this content.

Problem is, I am getting error 13 Type Mismatch on the second line.

Any clues anyone?

cheers
Pete

What is CTOID? I mean is it meant to be a Text String? Or what exactly?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Something like will work?

Please Login or Register  to view this content.

Thanks NeedForExcel,

CTOID is a number

I have this working on another instance for changing a password on a login sheet in the same workbook

Please Login or Register  to view this content.

Sample workbook would realistically take too long to prepare!

Pete

Thanks Parth,

Your clues provided the answer!
Here's my updated code:

Please Login or Register  to view this content.

cheers
Pete

thats grt pete