Userform cell reference help
 

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

Userform cell reference help
 

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.

--
Regards,
Tom Ogilvy
Pete wrote in message
...
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

Userform cell reference help
 

Tom

The userform shows up if cell A2A3. 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

-----Original Message-----
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.

--
Regards,
Tom Ogilvy
Pete wrote in
message
...
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


.