VBA Macro For Configuration

[devendra.dvm]

Yes

 

[Monty]

I just logged off....Typing from mobile...Just follow my instructions.

 

[devendra.dvm]

ok sure monty

 

[Monty]

Go to Developer Tab...Click on design and look at properties of list box for list fill range..

 

[Arpanakumar]

Monty

May be this...you are refereing to..where you can increase the rage of the list box contents.

Please confirm..Its time for me to prove am a big FAN and fallowing you.

 

[Monty]

Any confusion let me know ...I will login.

 

[Monty]

Hey Arpana...

You are right...That's how you can increase the range...Else..You also write code n workbook open event.

 

[Arpanakumar]

Thank youuuuuuuuuuuuu..

I remember this Workbook even..when you were explaning about combobox.

Private Sub Workbook_Open()
With ComboBox1
  .AddItem "Excel 2003"
  .AddItem "Excel 2007"
  .AddItem "Excel 2010"
  .AddItem "Excel 2013"
  .AddItem "Excel 2016"

End With
End Sub

 

[devendra.dvm]

Got it Monty

Thanks a lot..

 

[Monty]

I can sleep now...Please let me know any future projects...Hopefully your boss would be happy....Special thanks to Hui.

 

[jamesexcel1970]

Monty..Thanks to god

You are sleeping.

Cheers!

 

[Monty]

 

[Hui]

I think you may like this double click implementation to include Agents



Simply Double click in the Include Column

I have also fixed the sorting

 

[devendra.dvm]

Hi Hui..Thanks for the same

I Have checked the attachment and its working fine…And I want to mention three implementation

1) Output result getting replaced
For Example: If select first Agent in the list and hit upload button…Result coming perfectly

But in the same way if I select second Agent in the list and uncheck First agent and I will hit upload button now in output sheet First Agent data got cleared and second Agent data replaced

I want second Agent data will go and sit next below to First Agent Data

 

[devendra.dvm]

2) Please make changes in Output sort order as below

First Scheme level Ascending Order

Second Broke type id Ascending Order.

 

[Hui]

Here 'tis

 

[devendra.dvm]

Hi Hui...Excellent..

Working perfect...

*One more request..Please include an option "Select All" in Agent selection
*And consider Agent selection in output sort order..

Thanks in Advance

 

[Hui]

Here 'tis again

 

[devendra.dvm]

Thanks a lot Hui..

As Monty said you are really Excel Ninja..

I will start working with this Tool and i will definitely get back to you if i found any challenges in future..

 

[devendra.dvm]

Hi Monty...Thanks a lot for your help...I really
Appreciate your work…Had a great experience in forum.


Even I also became your fan as Arpankumar....An am excited to work with you in my future projects....

Thank you...Keep Rock