Write a vba script that looks for a cell between a1 and a10

Assignment Help Computer Engineering

Reference no: EM132216521

Write a VBA script (Macro) that looks for a cell between A1 and A10 that contains the number 5.

The script should generate a message box that reports this location (e.g., "Row 3") when it locates the number 5. Connect this VBA Macro to a command button on the worksheet.

Test this script with two different sets of numbers in column A and show screenshots of your results as well as your code in your answer.

Reference no: EM132216521

Questions Cloud

Write a code segment that prompts the user to enter sentence : Write a code segment that prompts the user to enter a sentence and then displays all of the words in the sentence.

Write a value returning function named sumofodds : Write a value returning function named sumofodds that takes two int parameters.

Calculate the vapor pressures for several pure components : Write a VBA-Excel program that calculates the vapor pressures for several pure components at different temperatures.

Simulate the roll of a pair of six-sided dice : Write a VBA script that randomly simulates the roll of a pair of six-sided dice and writes the sum of the roll to column A of the worksheet.

Write a vba script that looks for a cell between a1 and a10 : Write a VBA script (Macro) that looks for a cell between A1 and A10 that contains the number 5.

Write and test a function that is passed an array : Write and test a function that is passed an array of n integers and returns a pointer to the array cell that has the maximum value among the n integers.

Write three paragraphs or record a 1 min video : Write three paragraphs or record a 1 min video discussing the importance of documenting network problems and solutions.

Test a recursive method that takes an integer array : Write and test a recursive method that takes an integer array and returns the largest element in the array.

Write a turing machine that transformed the input string : The TM will first encode the constant value 10 to the left of the given input string, and then the TM will "call" the "Circle Shift Left by N" TM.

User Account

All Pages