Find Jobs
Hire Freelancers

Excel VBA - Interactive Form

$30-250 AUD

Completed
Posted over 9 years ago

$30-250 AUD

Paid on delivery
I have a spreadsheet with employee data that needs to be managed via a user form. The attached sheet shows the data structure and the notes tab gives the rules and logic for the various fields in each record. The key aspect of the form is that the data must be completely managed via the. This includes deleting records, where the row number and sequence rows need to retain integrity.
Project ID: 6479903

About the project

38 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi , Thanks a lot for getting back . I am ready to take up the job . I am placing bid approximately . Please review the same and let me know if in case i need to revise the bid .
$150 AUD in 3 days
4.9 (57 reviews)
4.8
4.8
38 freelancers are bidding on average $153 AUD for this job
User Avatar
Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$100 AUD in 2 days
4.9 (220 reviews)
7.0
7.0
User Avatar
Excel developer since 1997 well versed with user forms. I can provide screenshots on request. Cheers.
$250 AUD in 7 days
5.0 (59 reviews)
6.5
6.5
User Avatar
Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions
$200 AUD in 2 days
4.9 (106 reviews)
6.4
6.4
User Avatar
Hi, my name is Sevinc. I am a 5-star excel & vba coding expert here, and I am ready to help you. pls check my profile and feedbacks first to have some idea bout the quality of my work. I had many similar excel/vba tasks, including creating interactive forms, all achived with 5/5 rating. I read your project descriptions, I checked your template as well... I exactly got what you need and ready to go ahead... kindly get back to me if you wish to proceed with a top-rated and reliable partner here. pls note that I only deliver best quality at a reasonable price...I bid my best for you to start...regards,
$200 AUD in 5 days
4.9 (101 reviews)
6.4
6.4
User Avatar
Hi, I am an Excel macro expert and would be happy to take on your project. Let me know and we can discuss further. Regards, Arul
$150 AUD in 3 days
5.0 (155 reviews)
6.3
6.3
User Avatar
A proposal has not yet been provided
$250 AUD in 18 days
4.8 (87 reviews)
6.1
6.1
User Avatar
Hi Mate. I am highly comfortable in design customized VBA forms for user interaction and making data entries. I have looked at data structure in attached file and I would be able to deliver a VBA form accordingly. Kindly discuss. Regards.
$160 AUD in 2 days
5.0 (44 reviews)
6.0
6.0
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$189 AUD in 2 days
4.9 (71 reviews)
5.8
5.8
User Avatar
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$133 AUD in 2 days
4.9 (56 reviews)
5.7
5.7
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$250 AUD in 15 days
5.0 (40 reviews)
5.4
5.4
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
$144 AUD in 5 days
4.4 (33 reviews)
5.4
5.4
User Avatar
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also accurate. I can't say I am the fastest programmer out here, but I will surely deliver as per your requirements. Do not hesitate to contact me for further details. Kind Regards, Jon
$250 AUD in 7 days
5.0 (30 reviews)
4.6
4.6
User Avatar
Hi, We can very well do the job for you. What we can provide is ; 1. Interface to make data entry. This will be user form based. 2. Option to retrieve data and edit it and save back 3. Facility to generate reports if you want. 4. Data will be stored in excel sheet in backend. Based on your requirements we do have some queries and we would also like to send you a dummy design. Kindly message for further details. Regards, Pal
$90 AUD in 5 days
4.9 (8 reviews)
4.4
4.4
User Avatar
Check my portfolio and contact me if intersted. Thanks, TOm ______________________________________________________________________________
$100 AUD in 3 days
4.9 (12 reviews)
4.2
4.2
User Avatar
Hi, My name is Dan. I am an expert in excel and userform design and coding. I have done a very similar project recently which included the features you have explained. Through this User Interaction form, you can completely manage the datasheet. I need a little clarification with the Sequence rows and row numbers. I see its currently formulated in your datasheet. So by retaining integrity of this data, do you mean to say, if a record is deleted, it must delete the sequence and row numbers alongwith it, while the rest of the records continue to retain the assigned Row and sequence number when it was initially entered. If so, I am thinking why not include it as part of the form. Please message me so that we can discuss further and proceed. Thanks ! Regards Dan
$166 AUD in 4 days
4.9 (7 reviews)
3.8
3.8
User Avatar
Hello, I have an example I would like to share with you that is somewhat related. I know in your description you say you would like all of the functionality controlled from the user form; however, I;m a little unclear how you would like all of the lines displayed in the form. The example i have might demonstrate a slight variation on your request that I think would potentially solve what you're looking for. If interested, please message me back so I can share an example. Thanks!
$110 AUD in 2 days
4.8 (11 reviews)
3.5
3.5
User Avatar
Hi there! My name is Conrad Gillard and I would like to help you with your project to develop a user form for your Excel spreadsheet. I have extensive experience with VBA programming to process data, and I am confident that I can develop the macro that you require. I guarantee that I will complete this project within 24 hours of you awarding it to me. To give you an example of my abilities, I recently completed a project on Freelancer to extract information from a spreadsheet and generate a PowerPoint presentation, while allowing the user to specify their preferences. This project also required the development of a simple interface and the use of VBA. If you check my profile you will see that I received extremely positive feedback on this project, due to the fact that I exceeded the clients expectations in terms of developing a reliable and user friendly spreadsheet. The client was also pleased by the fact that I responded promptly to all communications, and completed the job quicker than my promised schedule. Finally, you may be wondering why my bid is lower than average. The answer is that I am new to Freelancer.com and am currently in the phase of establishing a good reputation for myself. As I mentioned, if you check my profile you will see that the first seven employers who gave me the opportunity to prove my skills were extremely impressed. Thank you for your time to read my proposal and I look forward to working with you! Regards Conrad Gillard
$100 AUD in 3 days
5.0 (7 reviews)
2.7
2.7
User Avatar
Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done these type of similar projects before. Thanks Abhinov
$133 AUD in 3 days
4.9 (3 reviews)
2.5
2.5
User Avatar
PROJECT PROPOSAL >>>Layout Design will be submitted for approval in 2 Days >IMPLEMENTATION DETAILS: >>>Menus >>>User Friendly Layouts >>>Tips >>>Data Security >>>Coding Standards >>>Coding will be segregated, so Future function enhancement will be easy. >>>Code Maintenance will be provided About Me: VBA Excel Programming - DB Programming, Merging on 2 Worksheets into 1, Currency Conversion, VLOOKUP Projects & Pattern Identification Algorithm Expert Knowledge in Microsoft Word, Excel, Power point & Access Formatting of Microsoft Word is a plus. Thanks, Anto
$100 AUD in 10 days
5.0 (1 review)
2.2
2.2
User Avatar
Thank you very much for posting the project. Your project seems to be very exciting. I have vast experience in handling projects like this and have successfully delivered high quality dashboards which are very flexible to future changes, easily scalable to bigger data and easy to use. Based on what you described, we can do the following things Create a userform which has tabs to do the following things 1) Add new employee to the database 2) Delete an employee from the database 3) Update the details of an existing employee 4) Retrieve a list of employees based on filters given by the user and also sort the results based on sort conditions selected by the user. All these things can be done by retaining the integrity of the data. We can also built in some security systems in place so that no one can get access to the employee database. This is a very good project and we can do a lot more than what you are looking for. Looking forward to work with you on this project. Thank You
$222 AUD in 2 days
5.0 (1 review)
2.2
2.2

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
21
Payment method verified
Member since Jun 20, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.