Macbooks and MacBook Pros do not have video-in, so there is no way to do a direct connection via cable. Only the 27" iMacs have a video-in.
You would need to purchase something like the Elgato EyeTV.
A search of the forum will turn up a number of threads on doing this.