Userform loading

[DGP]

Hi,

Complete novice here so sorry if im not using the correct terminology.

I have a worksheet that I have created 2 userforms for, UserForm1 I want to load if the current row being used in column O states "parts oversized" or "parts undersized" and UserForm2 is the same apart from column Q states "parts overweight" or "parts underweight". This worksheet will be used as a database for results so I don't want it to trigger the UserForms on old rows, if that is possible?

I have the Userforms adding the additional data to the worksheet, but i can not get them to load if columns O or Q contain the text above, I don't know if its because columns O and Q are filled by an IF formula.

Any help would be greatly appreciated, code for loading userform below.

Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim cell As Range
For Each cell In Range("O:O")
    If cell.Value = "Part Underweight" Then
        UserForm1.Show
    If cell.Value = "Part Overweight" Then
        UserForm1.Show
    End If
Next cell
End Sub

 

[6StringJazzer]

I don't want it to trigger the UserForms on old rows, if that is possible?

It is possible, but what data tells you if a row is an "old row"? It would be helpful to show us what the data looks like.

Also, your code will run every time you merely select any cell on the sheet. I doubt that is what you intended.

Then it will check every cell in column O, but you said you don't what to check "old rows."

Also you are showing UserForm2 for underweight/overweight, but in your post you said you wanted to use UserForm1 for this situation.

If you just want to monitor when something in column O changes, it will be difficult because you said this is a formula. It is possible, just difficult. There is no event that fires when the result of a particular formula changes. The Calculate event will fire when something on the sheet is updated that causes a calculation, but it won't tell you what changed.