VBA in Excel and Access

I am short a developer and I need someone with experience in VBA (Visual Basic for Applications) and some desktop VB.NET

I have a number of SQL (2005 and 2008) databases with Microsoft Access (2007 and 2010) front end. These use Microsoft Access and VBA as the user interface and I need someone to help out on an ongoing bases. It is not a huge volume of work but it does come in small projects.

The specific project I have now is related to one of my databases. I need to develop a data collection form in Excel and VBA. The form will be e-mailed out and will be completed by field technicians and e-mailed back. I have started the form and have some working code but workload and priorities mean I need someone else to help out.

The Excel file contains 8 forms (Excel Worksheets) and 2 worksheets of data.

The basis is the user fills in the form and there are some fields that have upper and lower limits and some fields that require a look-up and auto complete. The data for the upper and lower limits is in the workbook (on one of the two data sheets). I need the developer to write some VBA code so that when the "cell update" event is triggered the code will compare the value entered to the value in the other sheet. If it is outside the limit the user gets a message and the cell focus is set back to the cell with the out of limit value.

This is not hard to do but there are 8 forms and each form has 25 to 30 fields that need validated (it is a lot but if the code is written correctly it can be cut and pasted) I am part way through the first form but I need someone to finish it and complete the other 7 forms using the same code template. I also need the developer to help lock the sheet so when it is sent to the user that they only enter data in certain fields.

When this project is done I will be posting a second project to write a desktop application to take the results entered and post them to a table in Access so there will be a bit of ongoing work.

For this Excel project I am estimating that there is about 2 or 3 hours work in each form. I am also assuming USD10 per hour so USD10 x 3 hours per form x 8 forms = USD 240 max

My two main criteria will be cost and quality. I am not going over 240 USD and I will be looking for someone who can come in under that and I am also looking someone who has some history of doing a good job (feedback) with VB development (either VBA or VB.NET)

Skills: .NET, Excel, Microsoft Access, Visual Basic

See more: visual basic x, visual basic net developer, visual basic for applications, visual basic developer job, visual basic cost, vba access developer, set bit in c, set a bit in c, part of microsoft excel 2007, need someone to do a excel project, Need help in excel, microsoft excel help 2013, microsoft access job, looking for job as sql developer, excel vba developer job, excel vba developer, excel form to enter data, developer of visual basic, developer cost per hour, data forms in excel

About the Employer:
( 9 reviews ) Armagh, United Kingdom

Project ID: #4941916

Awarded to:


HI, I can do the job, just send me the excel file to do the changes Regards Diego

$200 USD in 5 days
(41 Reviews)

31 freelancers are bidding on average $206 for this job


Hi We have read your [login to view URL] have completed 80+ big projects in last 5 years. Please check private message board for details.

$515 USD in 4 days
(30 Reviews)

Hi mitsystems, plenty of experience in Excel VBA,formulas + VB.NET... Should be able to help you out with ease. please reply. thanks !

$233 USD in 5 days
(191 Reviews)

We are interested in this work and good knowledge of vb .net and initial understanding of VBA

$240 USD in 5 days
(17 Reviews)

Hi, I have been developing bespoke Excel applications incorporating a good deal of VBA for 20 years plus. Quite a few projects on freelance, please see feedback. Manchester based. Off on hols to Wales tomorrow but I wi More

$200 USD in 8 days
(40 Reviews)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$184 USD in 5 days
(45 Reviews)

Hello, I have read complete project description and I am ready to start work on it. I will code in Regards Sujal

$240 USD in 7 days
(28 Reviews)

Hello I can help you to get it done quickly. Thanks Guru Venkat

$155 USD in 2 days
(22 Reviews)

Hello: Please have a look at the PMB for more details

$206 USD in 7 days
(6 Reviews)

UK-based developer, specialising in Access and Excel systems - have been developing systems since 1998.

$222 USD in 3 days
(12 Reviews)

Hi, Ready to start.... Regards

$222 USD in 15 days
(8 Reviews)

Hello. See PM please.

$238 USD in 7 days
(11 Reviews)

I could do this for you. Please check my Excel reviews. As far as the .Net stuff in future I am an expert with Windows Forms projects using VB.Net (I prefer 2010 if possible). I have SQL 2008 R2 and 2012 on line at al More

$160 USD in 3 days
(18 Reviews)

Hello, Can support you with this task. Have strong background in VB, VB.NET, SQL. Several projects were created here on freelancer as well, so you can see reviews. Will be available to start from Friday, and deliver pr More

$222 USD in 3 days
(12 Reviews)

Hi, I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-fr More

$240 USD in 7 days
(8 Reviews)


$100 USD in 3 days
(3 Reviews)

PLease read my pm message

$145 USD in 3 days
(18 Reviews)

Hi, I am having good Experience in VBA, MSAccess and have worked like this kind of migration for almost 4 Projects. I can do this for you...

$233 USD in 10 days
(4 Reviews)

Hi, Expert here. Ready to Start

$155 USD in 6 days
(7 Reviews)

Hello, I'm good VBA coder. Your project is clear and interesting for me and I'm ready to start right now. Please let me know if any questions Thank you

$160 USD in 5 days
(1 Review)

trust is key

$222 USD in 5 days
(8 Reviews)