Find Jobs
Hire Freelancers

Simple Excel VBA userform to edit data

$30-250 USD

Awarded
Posted about 10 years ago

$30-250 USD

Paid on delivery
We have a datasheet with 15000 records. We need to add data to new columns we have created. We need a VBA form created so we can easily navigate to the next row of data, show existing data, and add data to the new columns. The new columns will be populated using either listdown on the form or option buttons Here is very example of what we need: We have sheet with... Image Name Size c:/[login to view URL] james 55 c:/[login to view URL] sam 57 c:/[login to view URL] George 45 we want Image Name Size New Colour c:/[login to view URL] james 55 1 Red c:/img2,jpg sam 57 0 Blue c:/[login to view URL] George 45 1 Red So new would be added on form using checkbox or option button and Colour would be added using listbox We need about 200 option buttons and listboxes created (about 200 new columns). Data for listboxes will be in neighbouring sheet. IMPORTANT: each row has an image and we need the image displayed on the form. images are about 500-800 pixels
Project ID: 5460987

About the project

33 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
33 freelancers are bidding on average $129 USD for this job
User Avatar
Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel tasks, all achieved with 5/5 rating...I read your project descriptions carefully, I exactly got what you need and ready to go ahead if you wish to proceed with a top-rated and reliable partner here...I bid a very competitive amount for you. kindly note that I only deliver best quality at a reasonable price...awaiting your (+) reply to start...regards,
$105 USD in 3 days
4.9 (285 reviews)
7.8
7.8
User Avatar
Hi, My name is Jon and I will be happy to help you with this project. Please feel free to message me prior to accepting my bid
$138 USD in 1 day
4.9 (251 reviews)
7.6
7.6
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementaiton.
$80 USD in 0 day
4.9 (326 reviews)
7.6
7.6
User Avatar
Hi, I specialize in Excel VBA based projects and would be happy working on your project. Let me know and provide sample datasheet plus images for testing. Regards, Arul
$155 USD in 3 days
5.0 (173 reviews)
7.4
7.4
User Avatar
HI Dance. I have made very similar Excel rows browsing form in VBA before and it displayed the corresponding image too. It is quite something that you also need. Its good idea to add the new feilds in the existing form as it would give you a single interface to deal with. Kindly share the sheet so I may have a look. Regards. Usman.
$100 USD in 1 day
5.0 (70 reviews)
6.7
6.7
User Avatar
Hello, I have created such a VBA userform and module, which works on any table, reading the headings and offering a simple way to edit the columns' value in a row by row (record) base. Unfortunately I have no the option to upload files, so if you want to get an idea, send me a message and I will upload a few screenshots to see how it looks like. The useform has 2 tabs, one for editing (row by row), which shows the fields (columns) of one record (row) each time, and a second one which can be used for searching rows with specific criteria (1 or more). The useform window is resizable and contains scroll bars to facilitate handling many columns and/or lengthy values. Of course there are things which need adjustment to meet your needs: The image must be included and the listboxes for the new columns' potential values must be filled in. I can do that in 1 day. I will need the file for editing as well as the sheet which contains the possible values for the extra, new columns. Which Excel version are you using? (there are minor differences in VBA syntax, that's why I'm asking). A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA programs of any kind and difficulty level, for both training purposes and business. Looking forward to hear from you, Kind regards, chriskerpini
$80 USD in 1 day
4.9 (69 reviews)
6.5
6.5
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 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$166 USD in 7 days
4.9 (115 reviews)
6.2
6.2
User Avatar
Hello, I have done such project for tool inventory. It had images and was similar to yours project. One of my customers have named me Excel Guru. That I am not but I know very much about Excel and VBA. Please check my reviews, profile and portfolio and award me with trust. With regards, Tom
$111 USD in 3 days
4.9 (34 reviews)
5.2
5.2
User Avatar
Hello, I can make that form for you. In several of my recent projects in freelancer or in other sites I used forms to interact with / manipulate Excel Data. List boxes can be easily bound to existing columns, or VBA can be used to populate list boxes on the run. Putting Yes/No (1/0) values into excel from option buttons is not a problem too. Nor is showing the image on the form. Do message me if you want more clarification. Thank you & Best Regadrs Raad
$75 USD in 3 days
5.0 (32 reviews)
5.3
5.3
User Avatar
I can give you a solution that does not require "option buttons" because the DropLists appear automatically when you change something in an adjacent cell. I have completed a number of identical assignments already, and with almost thirty years’ Excel business expertise I would be delighted to produce and encode your User Form. As I work from home in the Midlands, communication will be straightforward. I can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the Milestone into the site and send me your existing material. I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK/Midlands across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. Would normally provide samples to let you judge my skill for yourself, but as you made this a "restricted" project I can't send an attachment unless you send me a Private Message first. You have not said when the work has to be finished? I have allowed three days to make the revisions and add the code, which enables you to view the work in progress and make any changes you want in that period. Hope you find this of interest and look forward to hearing from you Bob Allen-Turl
$136 USD in 3 days
4.6 (11 reviews)
4.5
4.5
User Avatar
I have extensive experience writing VBA userforms and code for Excel, as well as excellent ratings. Please see my previous jobs and ratings. I have done several jobs for employers from the UK.
$111 USD in 7 days
5.0 (9 reviews)
4.2
4.2
User Avatar
Hello I am working with MS-Excel and VBA for the past 12 years and have completed successfully a no. of excel VBA projects through freelancer.com. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from my clients until the job is fully done as per their satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
$66 USD in 3 days
4.8 (5 reviews)
3.1
3.1
User Avatar
Hi, Instead of placing two buttons I think there can be a simple solution to this. i.e a stand alone desktop application using Ms access at back end and VB at front end. With this combination you need to install MS access on your pc. I shall import all your excel data in to Access back end database. You will be able to add / delete / edit data. Images will be shown on the form as you require. I further need to discuss project detail with you. Looking forward to hear from you Regards, Asghar
$222 USD in 5 days
3.8 (2 reviews)
4.2
4.2
User Avatar
Hello, Thank you for posting this project and detailing it. After carefully reviewing your requirement, I would be glad to be a part of this. I can have userform created using traditional VBA or you could opt for a more sophisticated and robust solution by going for a VSTO com addin. In the later approach I will build an executable setup that will embed the application itself as an addin within the Excel environment. This will also involve better functionalities and features (The userform can be embedded within your Excel environment. Please check my portfolio for a sample overview). The addin approach will also add to teh aestetic appeal and will make your form look much better and presentable along with its controls (buttons, listboxes, etc) which will emulate the style of the application as opposed to the standard VBA controls. I am a Microsoft certified trainer (MCP Id: 7531519) with over 9 years of experience in delivering automation solutions to corporate staff. I look forward to discussing this further over a PM. Thank you
$150 USD in 2 days
5.0 (7 reviews)
2.6
2.6
User Avatar
Hi dance621, I am a professional consultant with a breadth of experience in Microsoft Office products specialising in data manipulation and the presentation of business intelligence or management information. I have the technical capabilities and commercial understanding to bring your requirements to life. I would be very interested in discussing your project further and establish a plan of action to meet your needs. I look forward to hearing from you. Kind regards, SMD.
$100 USD in 3 days
4.5 (5 reviews)
3.0
3.0
User Avatar
Hi there! I'm new in freelancer, however I have a lot of experience building macros to automate business processes. I care a lot about details and visual aspect of the stylesheet, I'm very responsible and I am sure you won't regret hiring me. Thanks in advance! Filipe Ramos
$66 USD in 3 days
5.0 (1 review)
2.1
2.1
User Avatar
A proposal has not yet been provided
$177 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi sir we aere ready for work your project Sir we provide you 100% sure work do you want with out any mistake... Sir we have already done some projects in excel sir do you want to see this ? Sir kindly i request you please reply we are wanting for your great response sir... Sir kindly tell me how much your budget? and how much time do you want to complete it ? please sir i request you... Many Thanks... Regards Maaz3213
$250 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi sir i am ready to work this assignment.I am highly experience about excel and i know about that work. I give you 99% good quality work. Sir i am new in freelancer but i know what you want that's way please give me this assignment. Thank you. Regard : SAAD
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Bracknell, United Kingdom
4.6
3
Member since Oct 20, 2009

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.