Good afternoon,
Newbie here with VBA, wondering how i can find a value where a formula exists when typing into an input box.
The code i have works where the value is present but I need to reference a different sheet to carry out the criteria which has formulas in the column. Hope this makes sense! Is it possible to do this?
Sub FindIssuekey() 'add a command button on your Master Sheet referencing this Macro
Res = InputBox("Enter An Issue Key")
Set Rng = Worksheets("Sheet 1").Range("B:B") '<< The Sheet Name and Range to Search
With Rng
Set MyChoice = .Find(What:=Res)
If Not MyChoice Is Nothing Then
Application.GoTo MyChoice
Else: GoTo ExitMyChoice
End If
End With
Exit Sub
ExitMyChoice:
MsgBox "Could Not Find " & Res
End Sub
Cheers
CM
Newbie here with VBA, wondering how i can find a value where a formula exists when typing into an input box.
The code i have works where the value is present but I need to reference a different sheet to carry out the criteria which has formulas in the column. Hope this makes sense! Is it possible to do this?
Sub FindIssuekey() 'add a command button on your Master Sheet referencing this Macro
Res = InputBox("Enter An Issue Key")
Set Rng = Worksheets("Sheet 1").Range("B:B") '<< The Sheet Name and Range to Search
With Rng
Set MyChoice = .Find(What:=Res)
If Not MyChoice Is Nothing Then
Application.GoTo MyChoice
Else: GoTo ExitMyChoice
End If
End With
Exit Sub
ExitMyChoice:
MsgBox "Could Not Find " & Res
End Sub
Cheers
CM