I need a Syntax code for a Userform I'm working on.
Its essentially a VLookup, with Dynamic Lookup Value, Dynamic sheet reference, and nested IF Functions for Column Reference.
-The Lookup Value comes from a text box from within the userform that is already dependent on the result in other textboxes via VLookup function. I currently have this set up as a text box that I dont really want seen, but its a value already drawn from a vlookup type function to find a product number for a product description. If there is anyway of removing this textbox and adding this to the full syntax code this would be great.
Product Number( Combobox98, the one i would like to remove if possible) = Vlookup Product Description (Combobox17), (Sheet "Index, range B18:C100) in column 2 (C) (written in syntax form within the code for change events on Combobox98)
- The Sheet reference value comes from combobox15 (the values are a dynamic list of accounts drawn from within a worksheet) from within the userform
- The Column reference comes from Combobox5 (the values are a list of container types drawn from within a worksheet {Closed Top, Open Top, Over Height & Jumbo}) within the userform, so needs some kind of nested IF function (Closed Top = Column 3 (C), Open Top = Column 4(D), Over Height = Column 5(E) & Jumbo = Column 6(F))
This function will return a price per m2 drawn from a heap of worksheets, each account has its own worksheet, with product codes down Column A, four different columns of pricing depending on the container size).
Also any help with the Email on Submit button would be great. Comboboxes 11, 12 ,13 &14 will provide the email addresses, but the body of the email should have the info from within the Userform, ideally laid out in the same way.
I have attached the file, but if there are any questions please ask.
Glenn
Hello,
I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
Hi,
You may not select the right candidate without knowing what your project on writing syntax codes for your Excel user form will look like. Fortunately, I can complete a part of your job before you award the project.
Before you award this project, I can complete a part of this project as a proof of concept. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project.
I’d love to discuss more on what would make this project a success for you. Can we have a quick chat?
Thanks for your time.
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement,
I might have a few question to discuss so I need you to send a message on chat.
Hi,
My name is Virendra.
An Experienced Data Analyst and Macro Developer.
I have read your instructions carefully.
I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA.
I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports.
I have done mostly Excel VBA Programming jobs.
Please check my portfolio to see my work –
https://www.freelancer.com/u/vsprybhanu.html?page=portfolio
So, I can do this job nicely.
Ready to start, please message me to discuss your project in more details.
Thanks,
Virendra
Hello!
I read your description carefully.
I've always done my project the fastest and highest quality.
I think your project is best for me.
The reason is that I am a VB expert.
If you want to check my skill, you can sure from my profile.
To confirm this, please see the link below.
https://www.freelancer.com/u/fastestJohn?w=f
If you choose me, I will do my best.
Thanks.
hi
I have a lot of experience in data processing, checking and fixing errors in excel. I can help you fix this error very quickly and accurately. Hope can be cooperated with you.
Hello!
I have briefly read the description on syntax-for-userform development project, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well. I reach out to see whether the opportunity is still available.
If the job’s no longer available, I’d appreciate you throwing my hat into the ring for any similar opportunities in the future. Here is my url: https://www.freelancer.com/u/VirtualBrainInc .
Thank you for your time, I look forward to hearing from you soon,
Best Wishes,
Kevin M
Dear Prospect Hiring Manager.
Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned
"I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
Writing Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters and Ph.d. programs.
1. Academic writing
2. Article/content/blog writing
3. Product description writing
4. Transcription writing
5. Logo designing
6. Autocad
7. Audio recording/voice recording
8. Picture illustration
9. SQL
10. Web Development and designing
11. Book designing
We are honored with a group of experienced online scholarly scholars who have capability in English dialect, alongside assorted subject information of Finance, Marketing, Accounting, Management, Statistics, Human Resources, and Information Technology
oour expert writers promise to convey brilliant quality in a manner that you need at most dependable valuing alongside a few different profits and administrations
Hello,
I have 15 years experience working with macros. I usually create my own forms and write them in VBA from scratch but I can work with your user form. I have written macros before that send emails. Do you want a copy of the form attached or do you want the text from the form added to the body of the email?
