Question: my vba code keeps getting the error that wrong number of arguments or invalid property assignment and it highlights findstate. How can I fix this

my vba code keeps getting the error that "wrong number of arguments or invalid property assignment and it highlights findstate. How can I fix this problem

Sub StateSearch() Dim state As String

InputBox "Enter a state you'd like to search for.", "State search" FindState state, isFound MsgBox "State was " & isFound, vbInformation End Sub

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!

Exploratory Data Analysis Introduction This chapter will show you how to use visualisation and transformation to explore your data in a systematic way, a task that statisticians call exploratory data...

Discuss Semantics and the challenges they are in English. 2 Language Structure and Use Learning Outcomes After reading this chapter, you should be able to ... Explain how language contributes to...

Read Classroom Glimpse. Discuss stress, rhythm, pitch, and intonation based on the tale in the classroom 2 Language Structure and Use Learning Outcomes After reading this chapter, you should be able...

You may practice teaching and learning tactics. Create a list you may use in class, others, and as a solo instructor. 2 Language Structure and Use Learning Outcomes After reading this chapter, you...

This is part of a larger Java code I was working on. My code keeps getting stuck here and looping without being able to exit. This code is meant to ask if they want to run the main code again. The...

My code keeps getting the error: Invalid student data: 1 0 0 Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: Index 1 out of bounds for length 1 at...

IN ML!!!!! datatype token = ID of string | EQ | PL | MI | TI | DI; fun createlist(c:char, file:TextIO.instream) : token list = if Char.isAlpha(c) then word(TextIO.input1(file), file, acc [c]) else if...

I'm trying to get more familiar with return statements and this code keeps getting flagged for "missing return statement". I don't understand this because i have return statements in each if...

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

Sassa Company owned 50,000 ordinary shares of Bond Company. These 50,000 shares were purchased by Sassa in 2011 for P120 per share. On August 30, 2013, Bond distributed 50,000 stock rights to Sassa....

R.E.C. Inc.'s staff of accountants finished preparing the financial statements for 2010 and will meet next week with the company's CEO as well as the Director of Investor Relations and...

How much does the design of an advertisement cost? 1 , 5 0 0 6 , 0 0 0 9 , 0 0 0 1 2 , 0 0 0

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...

2. Organizational politics should have no role in the administration of public programs.

If we asked your friends to list your best leadership qualities, what do you think they would say?

1. It is important to get along with everyone in organizations, even people you do not like.