What I am having problems with currently: For example, there will be a button that will be titled 'Deal', and pressing this will present two cards in front of you, and show one card in front of the dealer. although macros are the last thing i will add (so they are not currently on there), I have been making extensive notes on what each macro will perform. with all this information running in the background, I have a prettier front sheet (that looks more similar to a blackjack table at a casino) that then displays this. i have a wide array of if formulas working upon this data to then dictate by the number that appears what card this displays, and what this card then equals (so it works out that a Jack equals 10 etc). using the rand function to pick a number between 1-13 (as whole integers) - where 1=A, 2=2.12=Q, 13=K etc I want to find a way to simulate somebody dealing from a deck of cards. Enough of the introduction, lets get on with what i need help with Anyway, this time round, i am trying to create a simulator that will function as playing a game of blackjack. I know this is unlikely to be considered a useful or practical purpose for excel, however, i like to set myself challenges using excel to see if i can find a way of acheiving this (normally i can teach myself a few new more practical tricks along the way).
