How to write a VBA code to solve how many different ways a dollar can be broken into the following coins: half-dollars, quarters, dimes, nickels, and pennies? The code should export every possible...

How to write a VBA code to solve how many different ways a dollar can be broken into the following coins: half-dollars, quarters, dimes, nickels, and pennies? The code should export every possible combination into the Excel spreadsheet. After the code concludes running it should have a messagebox indicating the different ways you can break a dollar.