1. Is there a way that the cell that I double click shows up on the userform so we know what PN we are seeing?
2. The data that gets entered for each PN can it be seen every time it's being clicked on and not disappear when you exit.
3. The OK button on the userform does not work....
2. when someone enters information for that particular PN since they will all be different that if the anyone was to open the file that they too can click on it and see what was entered. The data can be stored on sheet4 for example.