VBA Macro For Configuration

[devendra.dvm]

Hi Monty

Any better result?

 

[Monty]

Not really...Looks impossible to me...Failed several times.

 

[devendra.dvm]

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.

 

[devendra.dvm]

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..

 

[Monty]

Hello Dev...Fair enough...As long as we getting a solution...God bless.

 

[Hui]

Can you please review this and let me know what you think?

Did you really want a Userform to run it ?

 

[devendra.dvm]

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

 

[Hui]

Do you want a user form or are you happy with the current interface?

 

[devendra.dvm]

Yes Iam ok with current interface..

 

[Hui]

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

 

[devendra.dvm]

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..



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.

 

[Monty]

@ Hui... You are truly excel Ninja..just modified your code.

@dev please try this..Solved first column from false to Scheme actual values.

 

[devendra.dvm]

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

 

[Monty]

Dev

Try this!

 

[devendra.dvm]

Thanks Monty..

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


May be this small change will help for the same

.Cells(x, 1) = wss.Cells(Scheme, 7).Value

 

[devendra.dvm]

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

 

[Monty]

Mr Dev.

As Hui Suggested looks fantastic...that is changing to true or false instead of making it bold by double click is not a good idea i belive.

 

[devendra.dvm]

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...

 

[Monty]

Dev.

For this i believe it should be developed in User forms,,Hui approach was very simple and better without any complications i feel..

 

[Monty]

Dev.

Let me give other way round.. Hold on.

 

[Monty]

Trying to figure out what you have changed...Now code is not working.

 

[devendra.dvm]

ohh

 

[Monty]

Try this.

Used Active X control for selection..

Hope this serve your purpose.

 

[devendra.dvm]

Thank you Monty...

Note: How add more Agents?

 

[Monty]

First confirm...R u happy with the style.