Swap Problem    

Input two integers and assign them to two variables IntX and intY , use a procedure to swap them. Name the procedure swapProcedure. Display the variable values in their swapped positions as outputs.

 

 

Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdSwap. Place the code under the Click event of a command button titled “Swap Variables”.

Flowchart Solution

Sample Screen Shots

VBA Solution Code