Update 2 cells based on result in selected cell

[primed]

Hi Guys,

The below code seems to be working for me, except after updating the value in the selected cell the corresponding result cells(nameCell & dateCell) dont get updated until i leave the selected cell and go back to that same selected cell.

Please Login or Register  to view this content.

Thanks in Advance.

Brett

[SjonR]

And if you use the code in a Worksheet_Change event?

[primed]

That was too easy for you
Problem solved.

Thanks
Brett