Hi All,

I pretty new to VBA. Been using R for most of my coding-projects.

Anyway, here goes:

I want to create a workbook that can handle individual games of Whist, the score and store input data.

I imagine that this can be done partly by hard-coding and partly by VBA'ing.

I really only need one function (say, WhistScore(arg1,..)) that takes arguments such as:

- Who got 'the announcement' (Name of Player) [Text]
- What type of announcement (Normal, Sun, ClearSun, Halves, Clubs) [Text]
- What is 'the partner ace' (Clubs, Spades, Hearts, Diamonds) [Text]
- Who is 'the partner ace' (Name of Player) [Text]
- Value of annoncement (0 [if ClearSun], 1 [if Sun], 7, 8, 9, 10, 11, 12, 13) [Integer]
- Trump (Clubs, Spades, Hearts, Diamonds) [Text]
- Score/How many tricks they got? [Integer]

From this, I should be able to call function WhistScore [Double], and calculate the total score.

Depending on whether the announcer is partner with himself or not, a new code should distribute the resulting points in a Score or Result Sheet. Preferably via a Button like: "Add to Score Sheet". And obviously in a new line, so one is able to track the progression of the game. This could maybe be a recorded function?


Last but not least, I want to create another button called, say, "Store Game", that stores the input (Announcer, Type_Of_Announcement, What_Partner_Ace, Who_Partner_Ace, Value_Of_Announcement, Trump, Score) in another sheet, so one is able to do some describtive statistics. This could maybe also be a recorded function?

Have any of you guys any experience with such kind of project? If so, please share. If I manage to create the workbook, I will post it, and everyone who enjoys a good game of Whist with some friends are free to use (and maybe improve) it.

Kindly regards,
Jens from DK