If the enchanted creature is tapped as a cost to cast a spell or to activate an ability that’s not a mana ability, Cryoshatter’s last ability will go on the stack on top of that spell or activated ability. Cryoshatter’s last ability resolves first (destroying that creature), then the spell or activated ability resolves.