Checking Active Cell Input

[Flapjack]

I would like to write some code that does the following:

I have a column where the user enters part numbers. Whenever someone enters one part number in particular, I want a dialog box to pop up and have them select from three options. Based on the option they choose, a corresponding part number will then be automatically inserted in that column in the very next row.

I'm new at this, so sorry if this is a basic question, but how do I do an If/Then check on the active cell whenever something is entered? In other words, I am not manually running a macro to check the range of cells. I want it to automatically check the users input and then run the macro if the part number they enter matches a number.

Thanks!

 

[Oaktree]

Try a worksheet_change event.

Right click on the tab of the input sheet, select "view code", and put something like:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = "my part" Then 'rest of code
End Sub

 

[Flapjack]

Thanks, Oaktree! That's working just how I want it.

Thanks!