I saw a movie years ago about about a guy who was very self-involved and treated women badly and dies suddenly. In limbo, he is given a chance to go back and make things right, but when he wakes up, he is now a girl. Any ideas?

It's Switch (1991) (http://www.imdb.com/title/tt0103016/)