Preheat oven to 350 degrees
Line a muffin pan with paper liners
In a large mixing bowl combine cake mix, buttermilk, vanilla, water and oil
Using a hand mixer beat on medium speed for approximately 2 minutes
Fill liners about ⅔ of the way full
Bake in 350 degree oven for 19-23 min
Insert toothpick in center to check for doneness
Allow to cool on wired racks
Insert piping bag into a glass tip side down and fold the excess bag over the glass.
Insert piping tip and make sure it's all the way to the bottom and cut where it needs to be cut
Fill with icing and use a clip to tie off the end.
Begin pipping frosting onto the cupcakes once they have cooled and top with sprinkles.
Insert sparkler pieces.