In this Visual Basic assignment, I developed an Excel-based data analysis tool using VBA to automate sales data processing and organization. I wrote multiple button-triggered procedures that used While loops, conditional If statements, and Excel’s built-in Range().Sort method to analyze and manage store sales information. The program counts how many stores reached at least $3,000 in sales, calculates the average sales for Oklahoma stores, identifies the highest and lowest sales values, and sorts records by store number, state, city, or total sales. I also used Cells() and IsEmpty() to loop dynamically through spreadsheet rows, ensuring the program works with varying amounts of data. This project strengthened my understanding of event-driven programming in VBA and improved my ability to automate repetitive spreadsheet tasks, analyze structured data programmatically, and build interactive Excel tools using Visual Basic.

In this assignment, I practiced using Do While loops in VBA to generate different number sequences and display them in a label. The program includes buttons that count upward, count downward, and count by 2’s in both directions. I also built a personalized loop option where the user can enter a start value, end value, increment/decrement amount, and the number of columns to format the output. This project helped me better understand how Do While loops work, how to control loop conditions, and how to format output neatly based on user input.

In this assignment, I practiced using For loops in VBA to generate different number patterns and display them in a label. The program includes buttons that count up, count down, and count by specific increments (like by 2’s). I also created a personalized loop feature where the user can enter a starting number, ending number, increment/decrement value, and how many columns to display. This part helped me understand how loops can be combined with user input and formatting to create organized output.

In this assignment, I created a math guessing game where the user has to solve an addition problem and enter their answer. The program checks the user’s guess and displays whether it is correct or incorrect. One of the main features I added was using an image control to display feedback visually. If the user guesses correctly, the program shows a happy face image, and if they guess wrong, it shows a sad face. I also included a checkbox option that allows the user to choose whether or not the face images should display. Another part of the project was adding difficulty settings using option buttons, which change the range of random numbers generated for the math problem. This assignment helped me practice working with conditional statements, random number ranges, and using images as part of a Visual Basic program. 

For this assignment, I learned more about using Visual Basic controls and how they work in an actual program. I practiced using option buttons and checkboxes, and I learned how to write code that changes text formatting like bold and underline based on what the user selects. I also worked with generating random numbers, and learned how to code it so the program produces whole integers within a specific range (such as 1 through 10). Another concept I practiced was swapping values between two textboxes, which required using a temporary variable to hold one value while switching them. Overall, this project helped me better understand user input, event-driven programming, and how different controls interact with the code behind the form. 

For this assignment, I developed a sales order form using Visual Basic in Microsoft Excel to calculate the total cost of a customer’s skate order. The program accepts customer information, tracks quantities for multiple product options, calculates a combined total, and applies tiered pricing based on order size. An additional discount is automatically applied for orders exceeding a specified total.

This project allowed me to practice working with multiple inputs, conditional pricing logic, and currency formatting. I implemented the pricing rules using both If / ElseIf statements and a Select Case structure, which helped reinforce how different control structures can be used to handle the same business requirements. The assignment strengthened my understanding of spreadsheet-based automation and real-world pricing scenarios.

For this assignment, I created a ticket sales calculator using Visual Basic in Microsoft Excel. The program calculates the total cost of a ticket purchase based on the number of tickets selected, applying tiered pricing where the price per ticket decreases as the quantity increases.

This project was implemented using two different approaches: one with If / ElseIf statements and another using a Select Case statement. Comparing these methods helped me understand how different control structures handle range-based logic and why Select Case can be more readable for tiered pricing scenarios. Through this assignment, I gained experience working with spreadsheet cells, currency calculations, and writing clear conditional logic for real-world pricing rules.

For this assignment, I created a grade comparison calculator using Visual Basic within Microsoft Word. The program compares a student’s average to the class average, calculates the numerical difference, and clearly displays whether the student is above, below, or at the class average. It also assigns a letter grade based on the student’s numeric score.

Through this project, I learned how to separate calculation logic from display formatting, particularly when presenting positive and negative values consistently. I also gained experience using conditional logic and Select Case statements to evaluate numeric ranges and make program decisions. This assignment helped strengthen my understanding of data handling, formatting output, and writing clear, readable code for user-facing results.

For this assignment, I built a grade calculator using Visual Basic in Microsoft Word that evaluates two exam scores. The program calculates the student’s average, determines pass or fail status, assigns a letter grade, and identifies whether the student improved on the second exam.

This project was designed to compare two different approaches to decision-making in code. I implemented the grading logic once using nested If statements and again using a Select Case statement, allowing me to see how the same problem can be solved in multiple ways. Through this assignment, I gained a better understanding of conditional logic, numeric comparisons, and choosing clearer, more readable structures when writing programs.

In this assignment, I developed a penny calculator that converts a total number of pennies into dollars, quarters, dimes, nickels, and remaining pennies. The project demonstrates two different approaches to solving the same problem: one using repeated subtraction after integer division, and another using the Mod operator to calculate remainders more efficiently.

Through this project, I learned how the Mod function works and how it can simplify calculations involving remainders. Comparing the two methods helped reinforce my understanding of integer division, control flow, and writing clearer, more efficient code. This assignment also strengthened my ability to evaluate different programming approaches and understand why one solution may be preferred over another.

For this assignment, I created a conversion calculator using Microsoft Word’s Visual Basic developer tools. The program takes user input for feet and inches and converts those values into feet, yards, and meters. I implemented event-driven programming through button controls, used variables to store and process user input, and applied formatting to ensure clear, readable output.

Through this project, I learned how Visual Basic handles user input, calculations, and form controls, as well as the importance of validating and formatting data for usability. This assignment helped reinforce my understanding of basic programming logic, unit conversion, and how simple applications can be built using built-in development tools.

For this assignment I created a Money Calculator using Microsoft Word and Visual Basic for Applications (VBA). This project gave me more practice using Developer Tools and ActiveX controls. I learned how to use " _ " to organize code on multiple lines. I also tried some color customization with the buttons. 

For this assignment, I created a simple calculator using Microsoft Word and Visual Basic for Applications (VBA). Through this project, I learned how to enable and use Developer Tools and ActiveX controls within Word. I applied standard naming conventions for text boxes, labels, and command buttons to keep the code organized and readable.

I also customized the calculator’s design by adjusting font sizes and colors, resizing buttons and input fields, and arranging the layout for usability. In addition, I programmed the button functionality using VBA to perform basic arithmetic operations. To improve reliability, I implemented basic error handling, including messages for missing input values and preventing division by zero.