Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need some help with VBA in Excel!! Thank you!! a. Use an input box to ask the user to enter a string without any blanks
Need some help with VBA in Excel!! Thank you!!
a. Use an input box to ask the user to enter a string without any blanks (leading, trailing or between b. If the string entered by the user is an empty string, then use a message box to tell the user c. If the string entered by the user has any blanks, then use a message box to tell the user something d. If the string is an empty string or has any blanks, repeat step a until a nonempty string without e. If a valid string is entered, then create another string by replacing each character of the entered f. Use a message box to display the created string to the user; add an information message icon. words) and assign it to the string variable something like "The string is empty!".; add a critical message icon like "The string may not contain blanks!"; add an exclamation message icon blanks is entered. (Hint: Use Do Loop.) string with the character following it on the ASCII table. (Hint: Use For Next Loop.) a. Use an input box to ask the user to enter a string without any blanks (leading, trailing or between b. If the string entered by the user is an empty string, then use a message box to tell the user c. If the string entered by the user has any blanks, then use a message box to tell the user something d. If the string is an empty string or has any blanks, repeat step a until a nonempty string without e. If a valid string is entered, then create another string by replacing each character of the entered f. Use a message box to display the created string to the user; add an information message icon. words) and assign it to the string variable something like "The string is empty!".; add a critical message icon like "The string may not contain blanks!"; add an exclamation message icon blanks is entered. (Hint: Use Do Loop.) string with the character following it on the ASCII table. (Hint: Use For Next Loop.)
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