Closed Thread
Results 1 to 2 of 2

Show look up results in user form and display warning if overwritting existing entry

  1. #1
    Registered User
    Join Date
    12-26-2010
    Location
    hkg
    MS-Off Ver
    Excel 2003
    Posts
    1

    Show look up results in user form and display warning if overwritting existing entry

    Hi GuRUss,

    I have an excel worksheet for entering invoice data. (pls look at the attachment)
    I would like to add another function on the same userform so that it could display historical data as well. Whenever i happened to overwrite the old data, a warning message will be prompted.

    Any ideas on the aforementioned problem?

    Please help.

    YJL
    Attached Files Attached Files

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Show look up results in user form and display warning if overwritting existing en

    yapjooleong,

    Please review our rules about cross-posting. Note that cross-posting is not forbidden, but that a link to the cross-post must be provided.

    This link explains why.

    It looks like you are getting response in the other thread. I'm locking this thread and letting the question be addressed in:

    http://www.ozgrid.com/forum/showthread.php?t=149258
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

Closed 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