Changed Cell to Userform to Write Another Cell
Hello. I just started learning VBA yesterday and am trying to do this:
Let's say I have two worksheets (Sheet 1: "Presentation" and Sheet 2: "DataEntry"). Each worksheet has an identical 3x3 matrix in the upper-left corner (so A1:C3). I want to, using macros only, make a cell in "Presentation" match its corresponding cell in "DataEntry", each time a value is changed in "DataEntry" (and I do not want to restrict cell values to numbers-only).
Additionally, I want a form to pop up, immediately after changing a "DataEntry" cell which:
1) Presents the newly changed value from "DataEntry"
2) Offer me a chance to enter in a different value for "Presentation"
3) Give me a "OK" or "Submit" button
4) Allow me to cancel the copy operation via "Cancel"
Screenshots and current file attached.
| Attachment | Size |
|---|---|
| Presentation Tab Online.xlsm | 20.03 KB |
| Presentation Tab.png | 42.37 KB |
| DataEntry Tab.png | 41.53 KB |
Link to my answer
Hello, joedirty,
If you still need help, please look to my blog post where I attached a file with my solution.
excelexperts.com/reply-forum-topic-changed-cell-userform-write-another-cell
Best regards.