Excel VBA Treeview help needed - Urgent

I currently use a variation of the Excel VBA treeview tool (see [url removed, login to view]) 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.

Habilidades: Excel, Visual Basic

Veja mais: vba work, sap hr project, help needed ads, excel help needed, excel vba with, excel vba help, excel vba and, vba e, treeview, sap security, project on vba, jkp, excel/vba, excel small work, create excel worksheet, vba help, visual basic problems excel, vba small code, vba add excel, small vba, security label, create excel file vba, add sap, written file excel, vba small

Acerca do Empregador:
( 10 comentários ) London, United Kingdom

ID do Projeto: #6838875

Concedido a:


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 Mais

£61 GBP em 1 dia
(75 Comentários)

7 freelancers estão ofertando em média £131 para esse trabalho


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 refere Mais

£100 GBP in 0 dias
(239 Comentários)

A proposal has not yet been provided

£185 GBP in 2 dias
(122 Comentários)

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 reso Mais

£160 GBP in 2 dias
(54 Comentários)

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 Enginee Mais

£150 GBP in 3 dias
(25 Comentários)

Hi I can assure you that i am having the best excel experience and i can do almost everything possible with excel. Please check my review in IF you need see some samples of my work, then, pleas Mais

£168 GBP in 3 dias
(6 Comentários)

Dear Sponsor, I am a hard core developer with 14 years of experience in software development with Java (3Y), C++ (10Y), C#(3Y), Visual Basic, Excel, VBA programming, Web programming, HTML5, PHP, MySQL, Linux and Win Mais

£94 GBP em 1 dia
(0 Comentários)