+ Reply to Thread
Results 1 to 1 of 1

search userform looking up wrong cell on sheet

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    search userform looking up wrong cell on sheet

    hi
    i have a search form,my problem is when i enter a new entry eg,b80 and fill in all textboxes and click add all seems to work,when i enter b80 again sub order no
    comes back as wrong no,have checked all code and on saving it goes to cell "m",but when i want to update it looks like its reading "i",i could have missed something,but totally confused now
    cheers colin
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transfer Userform data on 1 worksheet to different worksheet (empty row = wrong sheet)
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2014, 10:08 AM
  2. Replies: 0
    Last Post: 02-27-2014, 04:43 PM
  3. Search and Display in another sheet Using VBA and userform
    By Simar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-22-2013, 03:35 PM
  4. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01:06 PM
  5. more than 1 cell as search range: result is wrong
    By astar24 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-09-2009, 12:31 PM

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