call macro from combo box

I had some help earlier; where I'm trying to have a macro run once its selected from a combo box - and this code works well:

Please Login or Register  to view this content.

What I'm getting hung up on is the macros only run if its numbers populating the combo box, say if my linked cells read 1-7 that would work but Sunday-Saturday does nothing. Is there something in the properties menu or in the coding that can read numbers but not characters? Thank you