Change Cell Value Dependent Upon List Box

[CKRebel]

Hi, I'll start by saying thanks to every one that helps with this matter.

I'd like to run a macro each time the value of a cell changes in a list box. More specifically, I have a Lookup function in cell F5 that is dependent upon information selected in cells F3 and F4. While this function works properly, it does not add room for a seperate user input should the user decide to input a different value. I figured if I just ran a macro that said "If Cell F3 = "Custom", then F5 = "User Input Value", Else "=VLOOKUP(.....)". Anyways, I'm looking for help on the matter, so if there is a much more efficient way to do this I'm more than welcome to suggestions.

Thanks again!

[Tinbendr]

You don't say what kind of listbox or where it is, but this will work for ActiveX listbox on sheet (put in sheet code page), and Listbox on userform.

Private Sub Listbox1_Change
select case Range("F3").value
Case "Custom"
   Range("F5").Value = "User Input Value"

Case Else
   Range("F5").Formula = "=Vlookup..."
End Select