Enter Address see if it is in range or not
Closed
Don
-
Nov 12, 2009 at 02:08 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 13, 2009 at 07:26 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 13, 2009 at 07:26 PM
Related:
- Enter Address see if it is in range or not
- How to enter @ in laptop - Guide
- Postal address of my location - Guide
- What is my ip address on my phone - Guide
- Dns address could not be found android - Guide
- Enter is send in whatsapp - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 12, 2009 at 08:36 PM
Nov 12, 2009 at 08:36 PM
your data is like this column A
address
200 Maple st
1589 Oak st
10000 Main St
30 Brown St
Put a button on sheet 1 and name it as you like it.
assign the following macro to that button
if the macro serves your purpose POST CONFIRMTION
address
200 Maple st
1589 Oak st
10000 Main St
30 Brown St
Put a button on sheet 1 and name it as you like it.
assign the following macro to that button
if the macro serves your purpose POST CONFIRMTION
Sub test()
Dim r As Range, cfindx As Range, x As String, y, cfindy As Range
On Error Resume Next
Set r = Range(Range("A2"), Range("A2").End(xlDown))
x = InputBox("type the street name eg.maple st")
y = InputBox("type the door number e.g. 200")
Set cfindx = r.Cells.Find(what:=x, lookat:=xlPart)
If Not cfindx Is Nothing Then
MsgBox "the street name is available"
GoTo findnumber
Else
MsgBox "the street name is not available"
End If
findnumber:
Set cfindy = cfindx.Find(what:=y, lookat:=xlPart)
If Not cfindy Is Nothing Then
MsgBox "the number and street name is available in " & cfindx.Address
Else
MsgBox "that address is not avilable in the range"
End If
End Sub
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 13, 2009 at 07:26 PM
Nov 13, 2009 at 07:26 PM
quote
then display Column D corresponding to the row
unquote
not clear. for e.g. D1 already has entry service 1. what is to display in D1?
then display Column D corresponding to the row
unquote
not clear. for e.g. D1 already has entry service 1. what is to display in D1?
Nov 13, 2009 at 08:00 AM
Column A Column B Column C Column D
Street Name Lowest Street Number Highest Street number Services Available
Maple St 100 1500 Service1
Maple St 1501 2000 Service3
Brown St 1 1000000 Service2
The above is what i'm working with. If they enter address "500 Maple St" I need it to find the street and then check if the address number is between B1 and C1 and if it does display Column D. Also, sometimes there will be more than one street with different ranges of street numbers because they can get different services.
So, if they type the address in it needs to say "Number and Address in Range" then display Column D corresponding to the row. Sorry again. I couldn't get the Macro you sent me to work, but i had my information wrong. Thanks for your help.