Escape key for '

Hi all

Pls advise on the escape keycode for '
When I tried to execute the insert statement using VBA

insert into (name,comment) values ('John','Terminated. He didn't submit assignment.');

It keep prompting me error becoz there is a ' in didn't