Find Jobs
Hire Freelancers

Excel VBA Error With ComboBox

$10-30 USD

In Progress
Posted about 8 years ago

$10-30 USD

Paid on delivery
I have most of the code by myself except there is one part of the code that does not work I need help. I have set up a combo box that has three inputs 1.Part# [login to view URL](icol string) 3.Value. The code that is written will check to see if the part# is found in column A and if its not found I want to add that new part to the last row on column A. This part of the code works fine the thing that does not work is when the second input is used (Month). The current code will add the part not found in column A, but if I select "current +2 it will not add the value to column "O", or respectively. Example. [login to view URL] (Not found) 2. Current Month +3 (Columm "P") 3.200 (Add 200 to column "P", that matches the part)
Project ID: 10144114

About the project

23 proposals
Remote project
Active 8 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
Hello, I can help you to solve this issue. I hope hear from. you soon, Luis Romero
$12 USD in 1 day
5.0 (164 reviews)
5.9
5.9
23 freelancers are bidding on average $28 USD for this job
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) please chat me, and i can help u Sir :) Thank You Sincerely Prameswara
$15 USD in 0 day
4.9 (420 reviews)
7.4
7.4
User Avatar
Hello! I understand the requirements of your project and I can do this project for you quickly and successfully . I'll work for the lowest price because I want to build a reputation on freelancer.com . Please, give me a chance to show my quality and help me to build a good reputation for my feature jobs.I am a new freelancer but I have long time experience with Microsoft Office (Word, Excel),Data mining , web search etc
$30 USD in 0 day
5.0 (202 reviews)
7.1
7.1
User Avatar
Hello, Thank you very much for this Data Entry Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can complete this Data Entry project on time and within your budget. I have worked on similar Data Entry projects, and I am confident I can exceed your expectations. Regards by Feroz Ahmed See My Feedback: www.freelancer.com/u/ferozstk.html
$30 USD in 1 day
4.9 (102 reviews)
6.6
6.6
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$10 USD in 0 day
5.0 (264 reviews)
6.5
6.5
User Avatar
Hi, I've checked your code and it is actually working well. But of course you won't see the value because those columns are hidden (including col O and P) When I tried to enter Current Month +2 in the Month comboBox, and enter value for Add/Subtract, it did add/subratct the value in column O of the coresponding part # in column A. That also works when I enter new part # in the new added row after the last row. I also tried Current Month +3, and it did the same for column P. Regards, Daniel
$15 USD in 1 day
5.0 (203 reviews)
6.7
6.7
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD in 1 day
4.9 (180 reviews)
6.5
6.5
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$30 USD in 2 days
4.8 (84 reviews)
6.2
6.2
User Avatar
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yellowpages,Yelp,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction, and the price is negotiable if required. please award me this project and contact me for further details
$25 USD in 1 day
5.0 (56 reviews)
4.8
4.8
User Avatar
Hello From what I can see you have formulas in those fields(columns N,O,P,Q).You can not change their value by just adding a number. Also why "Current month" is saved in column C and not M? I have a lot of experience working on VBA so I believe I can help you. Please feel free to contact me so we can talk it over. Thanks, Michael.
$15 USD in 1 day
5.0 (31 reviews)
4.3
4.3
User Avatar
Hi I am good at Excel VBA form handling. I have more experience in this. I should be able to fix this easily. Thanks!!
$25 USD in 1 day
4.6 (32 reviews)
4.3
4.3
User Avatar
Hi... I am ready to work on this project and let us have a discussion to have better understand of your need. Thanks!!
$10 USD in 1 day
4.6 (15 reviews)
3.3
3.3
User Avatar
Hi, I am a profession developer doing Excel macros/VBA code for corparate clients since 2007. Please let me know Regards, Param
$30 USD in 1 day
5.0 (3 reviews)
2.1
2.1
User Avatar
8 yeas of experience writing software in different leguages and platforms and vast experience in VBA
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can fix this for you in a few minutes, I will comment the code so you can understand what was wrong for the future.
$10 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I've written hundreds of VBA applications for my job (business analyst) and have debugged countless lines of code. I can easily solve your problem with the inputs as described, just let me have a go at it. Regards, Fred
$25 USD in 1 day
0.0 (0 reviews)
0.4
0.4
User Avatar
Hello, My name is David and I have been working on projects using Excel formulas and VBA code for some time. I can identify the issue you are having and give you some pointers that will improve your workbook. I am looking forward to working with you. Thank you, David
$28 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Elkhart, United States
5.0
1
Member since May 11, 2014

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.