brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I use the following code to enter a name selected from a listbox to the end of a list of names named "nameList"
I please need some help to prevent the name being added if it already appears in the list and a messagebox to appear advising that the name was not added because it is already in the list, can someone please help. After the messagebox appears, the code will continue running - it must not exit the subroutine.
> Application.Goto Reference:="R1000C3"
Range(ActiveCell, ActiveCell.End(xlUp)).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Unprotect
ActiveCell.FormulaLocal = ListBox1.Value <
I please need some help to prevent the name being added if it already appears in the list and a messagebox to appear advising that the name was not added because it is already in the list, can someone please help. After the messagebox appears, the code will continue running - it must not exit the subroutine.
> Application.Goto Reference:="R1000C3"
Range(ActiveCell, ActiveCell.End(xlUp)).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Unprotect
ActiveCell.FormulaLocal = ListBox1.Value <