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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started