+ Reply to Thread
Results 1 to 2 of 2

Userform Trying to Add Find & Edit button same like Excel Find All

  1. #1
    Registered User
    Join Date
    06-28-2014
    Location
    Bombay
    MS-Off Ver
    2007
    Posts
    33

    Question Userform Trying to Add Find & Edit button same like Excel Find All

    I want to add "Find & Edit" button and also a "EditNewRow_checkBox" to User from , This button will work on this four textboxes below
    -------------------------------------------
    Datebox | ServiceNo | UserName | Product
    -------------------------------------------
    the find button will have the property of editing/correcting the SAME ROW,
    if user search for ServiceNo for eg 123 of past month the Userform will auto populate the other texboxes like Datebox , UserName, Product falling in same row of table and he can edit it and the corrections made will remain on that row only.
    But * about EditNewRow_checkBox
    when the user have completed finding ServiceNo (the S...No may be of past Month may be it was on HOLD for some reason but now he have to complete that service ) so user want this to be edited but not on the same row. the editing when it is completed it should automatically go and dump itself in lastrow of table . ( in here the Hold service no in past month should be their itself but EDITED one should be dumped in lastrow of table )
    i know its confusing .

    actually i am tyring to do some thing like EXCEL Find app ... in which Find ALL kind of option also should be their.

    Please Help. with code. if possible

    Thanks in Advance

  2. #2
    Registered User
    Join Date
    06-28-2014
    Location
    Bombay
    MS-Off Ver
    2007
    Posts
    33

    Re: Userform Trying to Add Find & Edit button same like Excel Find All

    Thanks Friends to having Look at the POST ... i checked some of the POST of other with same issue and found that helpful. ...but i now have another issue for the same Find and replace ...i will raise another POST for that

+ 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] Lookup/Search/Find/Match then edit in userform
    By Cuba64 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 12-17-2013, 06:49 PM
  2. USERFORM: EDIT to include FIND, DELETE & CLEAR
    By srands in forum Excel General
    Replies: 2
    Last Post: 01-03-2013, 01:15 AM
  3. [SOLVED] UserForm Search Button to find original records?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2012, 12:09 AM
  4. Find Macro With Userform - To find a data across multiple tabs in excel
    By Testify in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-15-2012, 04:49 PM
  5. Userform Search, Find and Edit Data
    By Chris270 in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 08-24-2011, 05:36 PM

Tags for this Thread

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