Completed

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:

diegogarcia0531

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)
5.6

31 freelancers are bidding on average $206 for this job

qualifiedcoders

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

$515 USD in 4 days
(30 Reviews)
7.7
expertatwork

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)
6.0
parth1729

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

$240 USD in 5 days
(17 Reviews)
6.1
MDavidCrompton

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)
5.6
sonarkaushik

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)
5.7
envisionops

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

$240 USD in 7 days
(28 Reviews)
5.3
guruvenkat

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

$155 USD in 2 days
(22 Reviews)
5.3
AcuityInfotech

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

$206 USD in 7 days
(6 Reviews)
5.0
adaytay

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

$222 USD in 3 days
(12 Reviews)
4.8
ppn123

Hi, Ready to start.... Regards

$222 USD in 15 days
(8 Reviews)
4.4
andreiplinda

Hello. See PM please.

$238 USD in 7 days
(11 Reviews)
5.0
FLinCanada

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)
4.0
giorgitbs

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)
4.1
murtaza1981

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)
4.2
MaxTech3

hello......................

$100 USD in 3 days
(3 Reviews)
4.0
rbbahia

PLease read my pm message

$145 USD in 3 days
(18 Reviews)
4.1
pasrin

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)
3.2
hemsingh1

Hi, Expert here. Ready to Start

$155 USD in 6 days
(7 Reviews)
3.0
gobublik

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)
3.0
twinklekumar

trust is key

$222 USD in 5 days
(8 Reviews)
2.8