Create a interface/form using VB for an excel database



Hi there,

I have a bunch of index books that need to be transferred from hard-copy to digital. I planned to do this by creating an excel database with all of the information that I need. I would like to have a user interface made using Visual Basic/Macros that is user-friendly. I have had an attempt at making one but simply don't have the knowledge or patience required.

The essential features that the form would need to have are:

(refer to picture for clarity)

Add New Record - The form must have the ability for a user to simply type in information into blank textboxes, then press "Add New Record" and have it create a new row of information in the excel database.

Find Record - Using the same textboxes, if a user enters either a Last Name or a Reference Number, then presses "Find Record", it should search through the Excel database and find any matching records. If a record is found, the other boxes (which have not been filled out) should be populated with data from the relevant row of information that has been found. If there are more than one records found, the user should be able to cycle through the records using the "<<" and ">>" buttons.

Update Record - When a user finds a record using the above process, they should have the ability to edit information, such as the Notes or the client's address. When a user has edited information for the record, they should be able to press "Update Record" and have the relevant row of information updated, without creating a separate new row of information.

The rest of what is required is seen in the picture. The columns/textboxes needed are all there. There should be two drop-down menus (or ComboBoxes); one for "State" and the other for "Street Type". I can provide the list of options that should be in each drop-down menu.

The form seen in my attached pictures was my attempt of this, however the buttons don't work as there is no code. If this form is of any help or saves you time, I can provide this too.

Thanks in advance,


Skills: .NET, Database Administration, Excel, Visual Basic, Visual Basic for Apps

See more: features, create a picture, clarity information, advance excel+, excel advance, visual interface, visual basic form excel, Visual Basic Excel, vb excel, Excel visual basic, create an excel, create a excel, Advance excel, excel database visual basic, form update excel, client form excel, excel update net, visual basic database excel database, drop list database, macros excel basic, add macros, net excel add, advance search form, create reference list, database rest

Project ID: #5497291

Awarded to:


Hi Thank you for explaining the the project so neatly. I think I have all the info I need to start working on it. The picture and the explanation has made it all clear. If you take a look at my profile you'll fin More

$70 AUD in 2 days
(10 Reviews)