I have a shared workbook that acts as a database. The problem is that when two users entered data into the same cell, a conflict will occur and an error message box will be promted, asking the user whose data to discard. I was wondering if it is possible to execute these action, only when the error msg box pops up.
The main idea to accept the other users changes and have the local data moved into the next rowCode:ThisWorkbook.ConflictResolution = xlOtherSessionChanges Worksheets("Data").Cells(Counter, 1).Value = AAA Worksheets("Data").Cells(Counter, 2).Value = BBB Worksheets("Data").Cells(Counter, 3).Value = CCC Worksheets("Data").Cells(Counter, 4).Value = DDD Worksheets("Data").Cells(Counter, 5).Value = EEE Worksheets("Data").Cells(Counter, 6).Value = FFF Worksheets("Data").Cells(Counter, 7).Value = GGG Work Worksheets("Validation").Cells(2, 1).Value = Counter + 1
Featured
Writing your app was the hard part, but it’s not the last part. You still need to sell your app. Here's how to make sure your description puts your app in the best light. |
|
Reply With Quote
