Need the proper syntax to use Case/Select Case in vba properly.

That simple change did make it work perfectly thanks.

I'll continue reading on the proper use of Select Case since I've had little exposure to it so far. I thought it was used similar to an IF statement except Select Case allows for multiple situations/conditions.