+ Reply to Thread
Results 1 to 5 of 5

show message box when a duplicate entry is entered into a userform textbox

  1. #1
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298

    show message box when a duplicate entry is entered into a userform textbox

    Hello,

    I have a userform that enters data in column A, I would like to get a msgbox response if the same entry has already been entered into column A, if this happens then the sheet resets itself and the user has to start again.



    Please Login or Register  to view this content.

    Hopefully its a very simple solution but it has me stumped!

    thanks reg
    Attached Files Attached Files
    Last edited by reggie1000; 05-04-2012 at 05:46 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: show message box when a duplicate entry is entered into a userform textbox

    Hi
    Try this:

    vba duplicate check via textbox .xlsm
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298

    Re: show message box when a duplicate entry is entered into a userform textbox

    Thanks jraj1106,

    works great, thanks for your help.

    reg

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: show message box when a duplicate entry is entered into a userform textbox

    You are welcome ... Thanks for your feedback

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: show message box when a duplicate entry is entered into a userform textbox

    Reggie,

    Another method of doing it. (I was working on it, so thought of posting it, though you already have raj's solution).

    Please Login or Register  to view this content.
    Last edited by arlu1201; 05-04-2012 at 05:56 AM.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1