Create Excel-Userform (VBA) with dependent ComboBoxes
€8-30 EUR
In Progress
Posted almost 8 years ago
€8-30 EUR
Paid on delivery
Excel, VBA
Dear Sir or Madame,
I hope You can help me solving this problem:
I already have an Excel-Sheet and a UserForm. In the background a simple VBA-Code is running. You can find an example of this VBA-Code in the attachment files.
Now I want to add some features to this UserForm (NOT a new UserForm).
Some dependent ComboBoxes have to be added to the UserForm.
I have five information-Levels. Therefore I need 5 ComboBoxes. As an example:
In Level 1 we have the Options “A,B,C”. If I chose “A” the Level 2 ComboBox should only show entrys that belong to category “A”, for example “AA, AB, AC” and so on.
It would be great, if you could help me.
I'll pay 25 Euro for a good solution.
Hello
I am an excel expert and would like to bid on the project posted by you.
I have completed more than 100 projects in excel.
FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work.
Rgds
Rohit Pithisaria
Hi there. My name is Daniel and I would be glad to help you out with this project. I have more than 6 yrs working with ms-excel. I can guarantee an excellent job and deliver as soon as possible. Hope to hear back from you soon. Thanks,
Daniel
Hello,
I am very much interested to do this work as i have strong knowledge in excel VBA. I understand your requirements and i can do it efficiently. Looking forward to have a positive response from you.
Thanks
Hi,
I would love to help you with your user forms.
I am a reporting specialist by trade and I have extensive experience developing automated reports and user forms like this one in Excel using VBA. I encourage you to check out my profile and reviews.
Your solution should be relatively simple and I am confident I can deliver a completed product in just a couple of hours.
I look forward to discussing this project with you further.
Best regards,
Marcelo
Hello,
I have extensive experience with vba and user forms. I am actually working on a project (not on freelancer.com) where I am doing just what you need. My solution to this situation utilizes the "on change" event generated by each combo box when it is edited. I also included code to prevent selecting AA until A was selected (to prevent inconsistencies). Depending on you particular needs, this solution can be modified.
Looking forward to working with you on this project,
Harrison Eggers
A qualified accountant and finance professional possessing ‘can do’ attitude and passion to work thus yielding results for company in volatile & dynamic environment
A motivated self-starter, able to quickly grasp issues and attend to details while maintaining a view of the big picture. Expert in juggling multi-tasking and achieving on-time completion within budget.
Last but not least, having about experience of 3 years, starting as a trainee and then gradually moving up to the ladder to Accountant, I definitely have the right blend of skills to add value to an organization & developed my expertise in
SAP (FICO) Proficient in MS Excel,Word,PPT & Outlook
Financial Modelling using MS Excel 2010 Profound knowledge of Accounts & Reporting
Proficient in preparing 3-d charts & simulation Profound knowledge in IAS,IFRS,ISA’s
Hi,
Let me help you with your project.
There are a lot of combo boxes let me know where do you want to put them. Send me also listing of rows which must be added to each combo box.
I did several VBA projects and I think I can help you. Let me do your project and if you will like then you will be able to hire me (when I finish)
I made bid from mobile and there for I can't show you examples. Contact to me and I will show you.
Best regards,
Zaza
HI I can finish you project so fast pm me
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Hello Sir / Mam,
I am a professional with 12 years of experience in working with Excel and VBA Macros. I have developed some robust solutions for financial institutions, departmental stores and several mini projects.
Project Proposal :
There are two solutions to address this problem:
Setup 1: Solution in new workbook
A packaged solution where a user form will be created with 5 combo box which will display values depending on the values chosen from previous combo box. The combo box along with the VBA code snipped can be copied from the packaged solution into the desired excel workbook.
Setup 2: Solution in Actual Workbook
A packaged solution where a user form will be created with 5 combo box which will display values depending on the values chosen from previous combo box. The solution will be directly incorporated into actual workbook and tested for integration with other user form objects.
Note: Actual Workbook would be needed for implementation of solution.
Solution will be tested and the test results will be shared.
Please let me know if you need any queries or if you need any additional information.
If you decide that i will be a good fit for solving your problem, we can discuss the approach you would like to follow.
Best Wishes!!
Swathi