+ Reply to Thread
Results 1 to 3 of 3

Need search button and update button vba codes

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    41

    Need search button and update button vba codes

    Hi,

    I have a userform for data entry.

    I am able to make codes for Add ( Add entry to database), clear ( Clear userform ) , Cancel (Exit userform).

    I have some more buttons and functions to be assigned to them but not able to write code .It will be glad if anyone can help.

    Need codes for :

    1) Have search box which searches Mat id in the complete database and returns value in the search result listbox. When we click on the result in listbox , the userform values are filled with the values that the mat id has . Then if user wishes he can update teh details for that mat id , and click on update button . the data is updated in the database. Or he can delete the entry from database by clicking on delete button.

    2) Have arrows which will navigate through database ( need code for that ) .


    Thanks in advanced
    Mayur patil

    USERFORM.xlsm

  2. #2
    Forum Expert (Lazarus)
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    10 ... 21 - 32 & 64
    Posts
    2,722

    Re: Need search button and update button vba codes

    Cross posted: http://www.ozgrid.com/forum/showthread.php?t=178405

  3. #3
    Registered User
    Join Date
    04-10-2013
    Location
    Flintshire, Wales
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Need search button and update button vba codes

    Look in help for "Search function", this may be of some use.

+ 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