Hi,
I want a popup window reminding users to do something based on the following conditions:
if something is typed in column A (can be any cells), but the corresponding cells in column C does not have any value. However, if the corresponding cell in column C have a value (or users first type a value in it before typing in column a, corresponding cell), there should n't be any pop up message.
Any idea on how to do this?
Thanks,
put the code in the worksheet code module.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks.
But, how does it know if there is already a value in column C? If there is a value in column C (corresponding cell), then, no pop up window should appear for Colum A .....
For example, if the user starts typing in column A, cell 1 but there is already a value in column C, cell 1, then, there should be no pop up window informing the user of doing something...
However, if the user starts typing in column A, cell 1 but there is NO Value in column C, cell 1, then, the user will see the pop up message.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanks.
But, it is not working. Please have a look at the attached pic. I am interested in the cells that are highlighted; a sheet may have 20 of these sections. So, if the user types something in the small highlighted box and press tab to go to other cells, if there is a value in the highlighted big box, there will be NO POP UP window. Otherwise, a pop up messgae will be shown.
Thanks,Attachment 618569
I couldn't open the picture. It would be easier to help and test a possible solution if you could attach your file instead of a picture.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks