In Progress

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

About the Employer:
( 1 review ) Melbourne, Australia

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
(33 Reviews)

58 freelancers are bidding on average $122 for this job


Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n More

$200 AUD in 5 days
(519 Reviews)

Hi Mate. Not only I am highly proficient in VBA macros and Excel but I have done a few projects, involving the designing of input user forms, too. I have read the project description and seen the attached snap shot and More

$160 AUD in 3 days
(96 Reviews)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$222 AUD in 15 days
(127 Reviews)

VB and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstration More

$98 AUD in 7 days
(129 Reviews)

Hi, I have 5+ years of experience. Developed various projects in .Net with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related websites More

$154 AUD in 7 days
(79 Reviews)

hey philep10, we can create forms (similar to the one that you have attached) with full functionality. please reply and we can discuss further. thanks

$55 AUD in 2 days
(191 Reviews)

Hello, I have an 12 years of experience in .net technology with C#.Net, VB.Net, Asp.Net, Kendo UI, Asp.Net MVC with Sql Server, MySql, Oracle and Access. I have also same experience in HTML5, Css, Jquery and Ja More

$50 AUD in 1 day
(64 Reviews)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than More

$147 AUD in 4 days
(50 Reviews)

Hi, I'm a freelancer from India. I can do this job easily. I know VB and Excel well. Please check my reviews. I'll be waiting for your feedback

$133 AUD in 3 days
(57 Reviews)

Hi.. I have gone through your requirement in the description of the project in detail and feel comfortable in taking up the task. I have done several projects of data management and similar approach can be applied here More

$200 AUD in 10 days
(65 Reviews)

ready to start !!! ............................................................................................................................

$40 AUD in 3 days
(35 Reviews)

I have 8 yrs of Exp in VBA,VB6.0, and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start (i can do Excel + VBA and Access+VB also ,Access + VB is Better if u want i will also send More

$111 AUD in 3 days
(28 Reviews)

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft database More

$44 AUD in 2 days
(15 Reviews)

Hello I can do this work... Kindly Pm me for more details Waiting for your positive response Thank You

$66 AUD in 3 days
(45 Reviews)

Hi You seem good employer. Your task is perfectly explained. Just select me. I really want to do this project. You can also find me in Scype: Vasilchenko_Andrey,Kiev,Ukraine Remember about timesones. We have More

$50 AUD in 3 days
(44 Reviews)

Aucune proposition n'a encore été fournie.

$263 AUD in 10 days
(20 Reviews)

Hi Phil. Why pick me? Outstanding feedback on all projects without exception. I run my own Professional Excel & VBA Consultancy, On my business website you can view a wide range of portfolio exampl More

$175 AUD in 4 days
(17 Reviews)

Hi there, This can be done exactly as you required. The form would help too, as is already made and there's no point to make it from scratch. Adrian

$55 AUD in 2 days
(20 Reviews)

A proposal has not yet been provided

$388 AUD in 7 days
(7 Reviews)

Hello. I'm an experienced developer with multiple Microsoft certifications (MCP, MCT, MCAD, MCSD, MCDBA). I own a deep experience on .NET development and Microsoft database systems. I'm also a writer contributor with More

$111 AUD in 7 days
(5 Reviews)