VBA Macro (User Form)

[devendra.dvm]

Hi Experts,


I’m Back with my new project…Hope I will get the solution like my earlier post.


I’m working in stock broking company, Need to configure the commission rates for agents…In my earlier post I got the macro Tool for the same from well-known member “Mr.Monty” and Ninja “Mr.Hui”....same working perfectly and saving a lot of time…Thanks a lot to both Experts.


Now I required a similar VBA macro (User Form) to calculate differentials between Old Commission rates and New commission rates.

Please refer the attachment to understand the same.



In Sheet DATA:

· Column “T” ( Perc) Mentioned old rates

· Column “U” (GrossAmt) Mentioned Gross amount

· Column “X” (NetAmt) Mentioned Net amount

· Column “AB” (BrokTypeID) Mentioned Broke Type ID


Note: Data will be manually added in "Sheet_DATA"



Example : As per above table if Broke type is “1” differential commission rate is -0.50% then formula will be =-0.50% *M/100.

After processing this output should go and sit in result sheet..Have attached excel file for better understanding.

I hope these details are able to understand...Thanks in advance.

 

[devendra.dvm]

Cross post link: https://www.excelforum.com/excel-pr...ifferential-commission-rates.html#post4615695

 

[devendra.dvm]

Hi Experts...

Please help me on the same...

Thanks in advance..

 

[shrivallabha]

Devendra,

You have got no response here and limited (and probably the way you don't want) on the other.

You're expecting free help for a tailor-made solution (which you may get with bit of luck with someone willing to do for pastime or learning etc.).

But if you're thinking that this is the way forums work then it is incorrect interpretation. Forums work best when you work on it yourself (even if you don't know VBA you can start) and ask for advice where you are stuck. Many hands will help if you do that. In the process, you will gain some good VBA knowledge.

The other solution is going professional consultant(paid) if it is urgent requirement and you don't have time to wait until you develop. Good luck!

 

[devendra.dvm]

Hi Shrivallabha,

Thanks for your reply.

Your right...I am learning the same...but still im at initial stage only thats the reason im seeking help here..As you said i will try to adopt the knowledge on the same..