Question about a Vasectomy?

My husband has concerns about getting a vasectomy. I may sound stupid but we were wanting to know if he will still have *** and get off the same? Will his drive stay the same and s?