kellyhell
01-20-2012, 05:33 AM
Good Afternoon - could someone give me a hand with this?
When a user selects Yes from a drop down list in a particular cell a UserForm pops up to request further information.
How can I pass this information to the cells to the right of the "Yes" cell.
E.G. Cell H6 contains Yes, the UserForm info is to be passed to I6 and J6.
This needs to happen on each row everytime the user selects "Yes" -
Yes in H7, Userform info to I7 and J7 etc etc.
Thanks in advance
When a user selects Yes from a drop down list in a particular cell a UserForm pops up to request further information.
How can I pass this information to the cells to the right of the "Yes" cell.
E.G. Cell H6 contains Yes, the UserForm info is to be passed to I6 and J6.
This needs to happen on each row everytime the user selects "Yes" -
Yes in H7, Userform info to I7 and J7 etc etc.
Thanks in advance