Input Box Issue

[Dkeller12]

I am using the below code to search a column of data and I am getting an error when I enter a value that contains both numbers and letters (ex. 88006E) but does not cause an issue when using just numbers (ex. 880066). If I step through the process the error happens right after I enter the value in the input box and hit the OK in the box itself.

LSearchValue = InputBox("Please enter the CorpID to search for.", "Enter value")

What can be causing the problem? Is the input function itself limited to numerical values? I cannot figure it out.

Thanks in advance?

 

[Rick Rothstein]

I am using the below code to search a column of data and I am getting an error when I enter a value that contains both numbers and letters (ex. 88006E) but does not cause an issue when using just numbers (ex. 880066). If I step through the process the error happens right after I enter the value in the input box and hit the OK in the box itself.

LSearchValue = InputBox("Please enter the CorpID to search for.", "Enter value")

What can be causing the problem? Is the input function itself limited to numerical values? I cannot figure it out.

You need to tell us what error you are getting (so we have some idea what might be going on)? Also, did you Dim the LSearchValue and, if so, as what data type? My bet is you Dim'med it as Integer or Long and 88006E is not one of those data types, but that is only a guess until you answer the two questions I asked.

 

[Dkeller12]

The error is just a generic error message that I entered using the "On Error GoTo" function. The LSearchValue is dim'med and it dim'med as Long. What data type should I adjust this to so it takes both numeric and alphanumeric entries?

Thanks for the help!

 

[Rick Rothstein]

The error is just a generic error message that I entered using the "On Error GoTo" function. The LSearchValue is dim'med and it dim'med as Long. What data type should I adjust this to so it takes both numeric and alphanumeric entries?

Dim LSearchValue As String

 

[Dkeller12]

Perfect. Thank you for the help. Don't know why I did think of that and it fixed the issue.