Results 1 to 5 of 5

implement database search and edit function

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    16

    implement database search and edit function

    I have made a sheet for entering marks and roll number database.
    I want to implement search and save function in this sheet..
    In this sheet if we enter number of database it can be shows in respective textbox..
    for example if we enter 1 in the record number textbox....60 marks can be shown in maths mark textbox
    70 can be shown in science marks textbox and so on.
    I have implemented database entering formula in excel sheet through userform but i dont know how to get data from excel sheet to userform and edit/save it.so can anybody help me to coding for this function and as well as save, first record, previous record, next record , and last record button's vba code..!!???
    I have attached my sheet here for reference.

    Formula: copy to clipboard
    marks database.xls
    Last edited by dharmang1910; 09-15-2013 at 12:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search function in a database
    By silversurfa23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 06:25 PM
  2. Search & Edit Macro / Function
    By michaelweaver4 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2012, 06:23 PM
  3. Userform search and edit function help
    By adjustermn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2010, 03:35 PM
  4. How can I search Excel database and edit an entry?
    By saziz in forum Excel General
    Replies: 1
    Last Post: 02-08-2006, 04:30 PM
  5. Search & Edit in Excel Database possible?
    By saziz in forum Excel General
    Replies: 3
    Last Post: 02-02-2006, 05:50 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