Question: *IN VBA IN EXCEL* Write a program, and store it in a file called String Functions.xlsm, that does the following: (a) It asks the user

*IN VBA IN EXCEL*

Write a program, and store it in a file called String Functions.xlsm, that does the following: (a) It asks the user for a word with at least 10 characters and stores it in myWord; (b) it displays a message indicating the number of characters in the word; (c) it displays a message showing the first four characters of the word; (d) it displays message showing the last six characters of the word; (e) it displays a message showing the fifth character in the word; (f) it displays a message showing all but the first two and last two characters in the word; and (g) it displays the word in reversed order.(Hint: For the last part, look up String in the VBA library of the Object Browser.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

in excel using developer 1. (4 points) Open a workbook, get into the VBE, insert a module, and enter the following code: Public Sub NowYouSeeMe0 Dim myName as String, nMiles as Integer yourName =...

Q:

Question: This program plays a simple guessing game with the user. This Project will give you practice with while loops and pseudorandom numbers. You are going to write a program that allows the user...

Q:

Write a program, and store it in a Sub called StringsAreFun, that does the following: (a) It asks the user for a word with at least 8 characters and stores it in NiceWord. (b) It displays a message...

Q:

Problems 1. Prompt the user to enter a number n and calculate the square of the sum from1 to that number Output: For example, if user enters 10 the program would output (12+3+..10)2 552 3025. 2....

Q:

Please help me on this assignment! It's Java! Create a new class called Lab18GOM that is extended from JFrame. Make sure you store it in a file called Lab18GOM.java Enter your personal information at...

Q:

Working with FASTA data Modules you can use: sys (Links to an external site.) collections (Links to an external site.) os (Links to an external site.) re (Links to an external site.) argparse (Links...

Q:

Qu1) Write a Java program in a file called Three.java which uses a for loop to output the numbers from 1 to 10 (inclusive) followed by their squares each on a new line. That is: 1 1 2 4 3 9 and so...

Q:

This assignment is writing a python program on Linux for a parser for HTTP GET to read in lines of characters from standard input (i.e., the keyboard) and determine which lines, if any, are legal...

Q:

# The SL_Board class simulates a Snakes & Ladders board class SL_Board: def __init__(self, width, snakes, ladders): # Assumes the board is square (width wide by width tall) # Paramter: snakes: A list...

Q:

I need help with this question. We are going to design and build an authentication program that lets users create new accounts and login to existing accounts. When launched, the program prompts a...

Q:

Calculate three new columns. a) Percent change (up or down) in number of viewers from the March 25 data to the April 1 data for each show. b) Percent change (up or down) in rating for each show. c)...

Q:

Answer the questions from the information provided. 2.1 2.1.1 2.1.2 2.1.3 2.2 2.3 Use the information provided below to calculate the following: Net value of issues to the production department for...

Q:

3. Using a graphing software, draw each of the following graphs. (a) y = (2x - 3)/(3x ^ 2 + x - 2) (b) y = (x ^ 2 - 2x + 1)/(4x ^ 3 + x) (c) y = (2x)/(2x ^ 3 - x ^ 2 + 3x - 2) (d) y = (2x + 3)/(4x)...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

=+j Describe the various support services delivered by IHR.

Q:

=+j Describe the problems associated with implementing an effective global HR information system.

Q:

=+j Explain IHRMs role in global HR research.