Userform popup when entry in cell is specific

I have a worksheet where I enter in certain flight information. I have different pay item codes (FT=Flight Time, AV=Daily Availability, etc) that are entered. I would like to have a pop up form appear when the "FT" pay item code is entered. The form would include start time, end time, start from, end to, # of passengers, cargo payload, and mission code. When the ok button is push it would enter in this information on that particular line, and then disappear until the next time FT is entered. Is this a pipe dream or can it be down? Can anyone help me with this? Thanks.

I started a sample worksheet to work on and have created the userform. But I am stuck from here. Can you help?

Sure. Attach your file.

What you have done is much different than what you described in your first post. Originally you said you wanted to detect if the user types in FT, then bring up a form for them to complete the record. What you have implemented is to bring the form up when the user presses a button, and then complete the record. That's fine too, but I don't see what you need help with.

I started with the basics of creating a userform and attached it to a button to make sure it would work. Now I need to get it to pop up when the cells in column A has "FT". I have been trying the codes you suggested but I can not get it to work.

I started with the basics of creating a userform and attached it to a button to make sure it would work. Now I need to get it to pop up when the cells in column A has "FT". I have been trying the codes you suggested but I can not get it to work.

OK, I had to modify the code a bit to fit what you are doing. I preserve the ability to open the form by pressing the button.

You have several undeclared variables I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bug and runtime errors. I added Option Explicit statements.

Please Login or Register  to view this content.

If the form was opened by the user typing FT into a row, the Worksheet_Change will set FTRow. Otherwise FTRow will be 0. The form uses FTRow if it has been set, otherwise it uses your existing code to find the last row. That works but just FYI a more conventional way to find the last row is

Please Login or Register  to view this content.