canarycat123
New Member
- Joined
- Sep 1, 2021
- Messages
- 27
- Office Version
- 365
- 2019
- Platform
- Windows
Hi there, I'm looking for a string of code that can accomplish the following:
UserForm
1. UserForm contains two fields, 'Reference No.' and 'Reason'. Both are free text entry.
2. The value that has been entered into 'Reference No.' should then be matched against a range of data in Column A of another sheet.
Match Found
3. The entire row containing the matched reference number should be highlighted in red, then copy and paste 'Reason' into a note (or similar popup - I don't mind how that is achieved) against the matched cell reference (e.g. A4).
4. A message box is then returned to the user advising of successful implementation. The UserForm should then disappear.
No Match Found
4. If no match is found in 'Reference No.' then a message box appears advising of this. A simple of Ok will suffice which then leads back to the 'UserForm'.
I appreciate this is quite lengthy, I've tried everything within my knowledge base (limited!) but have been unsuccessful.
UserForm
1. UserForm contains two fields, 'Reference No.' and 'Reason'. Both are free text entry.
2. The value that has been entered into 'Reference No.' should then be matched against a range of data in Column A of another sheet.
Match Found
3. The entire row containing the matched reference number should be highlighted in red, then copy and paste 'Reason' into a note (or similar popup - I don't mind how that is achieved) against the matched cell reference (e.g. A4).
4. A message box is then returned to the user advising of successful implementation. The UserForm should then disappear.
No Match Found
4. If no match is found in 'Reference No.' then a message box appears advising of this. A simple of Ok will suffice which then leads back to the 'UserForm'.
I appreciate this is quite lengthy, I've tried everything within my knowledge base (limited!) but have been unsuccessful.