Input Box Help!!

[wpjensen]

I have a macro that does what I want but I want to make it easier to usethis is what I Have

[Set r = Range("A3:A1000")] is it possible to have a input box for the RANGE ????

[For i = 9250 To 9999] also is it possible to have a input box for what to search for ??

I have been looking for some clues on the internet but don't know enough
about VB macros to do this

Any help would be appreciated. Wayne

 

[JoeMo]

I have a macro that does what I want but I want to make it easier to usethis is what I Have

[Set r = Range("A3:A1000")] is it possible to have a input box for the RANGE ????

[For i = 9250 To 9999] also is it possible to have a input box for what to search for ??

I have been looking for some clues on the internet but don't know enough
about VB macros to do this

Any help would be appreciated. Wayne

Take a look at the Input Box Method in VBA Help. Here's an example that addresses your first question:

Dim r as range
Set r = Application.InputBox("Select a range", type:=8)

 

[wpjensen]

Joe Found that and just finished testing the Range just before you answer thanks

but having a little more fun trying to get the next input box
would it basically the same

Dim i As Integer
  Dim nMissing As Integer
  For i = 8800 To 8830

Wayne