Find Jobs
Hire Freelancers

Excel VBA Treeview help needed - Urgent

£20-250 GBP

Completed
Posted over 9 years ago

£20-250 GBP

Paid on delivery
I currently use a variation of the Excel VBA treeview tool (see [login to view URL]) to create HR organisational structures for SAP (OM builder file attached).. This works fine, but now I have been asked to add functionality for Roles (security levels) when creating the structure. I have added all of this new functionality to the AfterLabelEdit event in the OM builder file. All of the code is already written and the label updates with the new Role. My problems that need resolving are: 1.) The caption showing the new Role (e.g. *^^HRADM) should be saved as the new key. This will enable it to be saved to the worksheet and back to the treeview correctly (I think). 2.) Any items in the treeview that have a Role attached should be displayed with a different background colour . This is an urgent project and these 2 things need to be resolved quickly (especially number 1). This is a small part of a much larger project. If you can complete this to spec you will be assured of further Excel VBA work on this tool.
Project ID: 6838875

About the project

7 proposals
Remote project
Active 9 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, I had done step1 already, this is why I post this bid. I found error and corrected it, also added commands to correct save of tree to 2 Worksheets (main and relations). I can post result as soon as my bid will be accepted. P.S. Also program change color already, but I not added yet "save color of node to worksheet" option. Regards, programmer Aleks
£61 GBP in 1 day
5.0 (75 reviews)
4.9
4.9
7 freelancers are bidding on average £131 GBP 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 GBP in 0 day
4.9 (239 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
£185 GBP in 2 days
4.8 (122 reviews)
6.7
6.7
User Avatar
Hi there. I am Usman and I have been working with VBA Excel for a long time. Kindly discuss your problem with more details to fully understand it. I am very comfortable with treeview control and I shall be able to resolve your problem. Regards.
£160 GBP in 2 days
5.0 (54 reviews)
6.2
6.2
User Avatar
Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, conjoint surveys, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
£150 GBP in 3 days
4.9 (25 reviews)
5.2
5.2

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
10
Payment method verified
Member since Jul 20, 2012

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.