Userform cell reference help

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I want a userform to show up based on a certain cell info
change. I want the userform to have box that tells me what
the cell changed to to make the userform show up.

Example if cell A2 > A3 then show userform 1. within the
userform I want to state that cell A1 is equal to ___?

Any thoughts/ideas
Pete
 
You talk like A1 triggers the userform, but show a criteria of A2 being
greater than A3. what causes the userform to show. If a cell value, what
causes the cell value to change.
 
Tom

The userform shows up if cell A2>A3. Depending on how much
the difference is, cell A1 has a formula that calculates a
# based on the info in cell A2. I want to know what that
number in cell A1 is by having it show up in the userform1?

Pete
 
Back
Top