• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Macro For Configuration

ohh..:( my bad luck

your the only hope for me...still thanks alot monty for your time..

hope u vl get a solution...tnank you.
 
Hi Monty.

I would like to inform you that i have posted the same project in other forum also....i let u know if i get any result and i will share the details...

Hope you will understand..
 
Last edited:
yes perfect...Please consider below three points also.

1) Required Clear button
2) Need an option to add scheme codes
3) Need an option to select Agent codes.

Thanks in advance
 
Hows this

The two tables are tables and so just Type new values below the existing data

I can change the sort order of the Output if you require also
 

Attachments

  • Sample @ Dev.xlsm
    33.4 KB · Views: 4
Hi Hui,

I have checked the attachment and its working fine but in output result getting as TRUE and FALSE in column A instead of scheme codes..

upload_2017-3-6_21-9-26.png

And is any other way to select Agents codes instead of drop down list...
My suggetion :

Type 1: Double click on agent code to select Agent codes.. (Agent code should become BOLD once double click on agent code

Type 2: Make a drop down list (Filter ) directly on agent codes to selct multiple agent codes.

Yes please make changes in output sort order as
First Scheme level:
MM
FS
TR
Hui

Then Broke Type ID:
1
2
3
10
11
84
85

Thanks in advance.
 

Attachments

  • upload_2017-3-6_21-8-38.png
    upload_2017-3-6_21-8-38.png
    40.2 KB · Views: 4
Last edited:
Hi Monty..

Thanks for your reply...i have checked your file...still there is problem in column A all agent codes are getting updated instead of Scheme codes.. In column A Schemes codes should come..rest all correct
 
Thanks Monty..

But still getting updated wrong values..In Column A these Schemes Codes should come

upload_2017-3-7_0-7-25.png
May be this small change will help for the same

.Cells(x, 1) = wss.Cells(Scheme, 7).Value
 
Now working fine after that small change in code.. Thanks monty..


Please make changes as i requested in earlier post..

And is any other way to select Agents codes instead of drop down list...
My suggetion :

Type 1: Double click on agent code to select Agent codes.. (Agent code should become BOLD once double click on agent code

Type 2: Make a drop down list (Filter ) directly on agent codes to selct multiple agent codes.

Yes please make changes in output sort order as
First Scheme level:
MM
FS
TR
Hui

Then Broke Type ID:
1
2
3
10
11
84
85
 
Of course your right Monty.
But some i need to configure rates to more than 50 Agents so selecting multiple Agents with True, False will make confusion...

May be Filter option for selecting Multiple Agents is good idea in my opinion...
 
Back
Top