Can my husband get shingles by sleeping in the same bed?

Probably not. If your husband has ever had chickenpox or been vaccinated against chickenpox, he doesn't need to worry. If for some reason he's not already immune to chickenpox, then he's at risk by just being around you, regardless of whether he sleeps in your bed.
With who? Shingles is a reactivation of chickenpox. He can get immunized if he's not had chickenpox, but sleeping with a shingles patient (you, I'm hoping) won't cause him to get it if he already has had chickenpox. Here's to the two of you being close and warm, physically and emotionally, without any fear.