userform

[Monty]

You meen data will repeat as many agents you select in the output sheet?

 

[devendra.dvm]

yes

 

[devendra.dvm]

 

[devendra.dvm]

Pls refer...upload and result screenshots

 

[devendra.dvm]

hi Monty...

hope ur online now...

 

[devendra.dvm]

Hi Monty..
hope u will come to online tomorrow..

 

[Monty]

Am still working on your project...Be awake!

 

[Monty]

Hello Dev.

Excel attatched!

As per your requirment it's completed after spending for 5hrs late night..Hmmm need to sleep for 2hrs now to rush for office.

1) So additionally there is Checkbox as per the screenshot which will select all and deselect all it's out of my interest i felt.

2) i Think one list box is enough for your multi selection of agents which will go and sit in output sheet..


How to test!

Just click on Select all checkbox then enter other fields and click output and check.

Hope you like this..We are good to go with project.

Sleeping time for now..Take care!

 

[devendra.dvm]

thanks alooot Monty...

Iam sorry.. i fall into a sleep ..

 

[devendra.dvm]

I am also going to office now... will check the same and let u know if any challenges is there...

Please make small changes...in upload sheet please remove unwanted columns and rows as i just mentioned all these for reference porpuse..i just required only one column to paste Agent codes and same agents should appear in agents selection box...

 

[devendra.dvm]

In the same way please remove unwanted rows and columns in output sheet also...As i just mentioned all these data for reference purpose only.

 

[devendra.dvm]

I required output sheet like this before updating fields in userform

 

[devendra.dvm]

And wen i select last Agent in agents box and uploaded...output starting from 8th row...


Output should start from Row-A even if i select last agent...

 

[Monty]

In the same way please remove unwanted rows and columns in output sheet also...As i just mentioned all these data for reference purpose only.


View attachment 38626

Hello Dev.

Basic clean up of your file like removing columns and rows you can handle as we are not aware of the importances of data.

iam sure project is completed as per your requirment.

Let me know any challenges as per the coding...Happy to help you!

 

[Arpanakumar]

Dear Monty.

I was going through this conversation "Userform" and quite interesting and i really appreciate for your passions.

As always your Fannnnnnnnnn

 

[Monty]

Thanks a Ton to chandoo..God bless you.

 

[jamesexcel1970]

Design it your self and you will get help with code to get it to work.

Ha ha ha

 

[jamesexcel1970]

Hi !

Reminders from New Users - Please Read :​

• Remember people are volunteering their time to help you.
  
• Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight.
• If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days.

So just wait at least a day before adding again any Up !
​

I totally agree

 

[jamesexcel1970]

Little champ.You wil not sleep and will not allow any body till you complete the help. Nice really enjoyed the conversation and download the file.Hope i may ask questions.Could not resist to give you likes Champ.

 

[Marc L]

Thanks & Welcome ! ​

 

[Derek McGill]

Ha ha ha

Whats wrong with my comment ?

 

[jamesexcel1970]

Whats wrong with my comment ?

Dear Derek...No hard feeling, really appreciate you, as you are requesting somebody to design the form and ask for a code...It's a gesture..Cheers

 

[Derek McGill]

devendra.dvm seems from his posts to not even try to solve his own problems or to modify code to get what he wants, I myself will try and when I am stuck ask for help ( See my post about ListBox ).

 

[Monty]

Great man.

Yes McGill, you are right,
i keep telling people and got feedback to me as well when am new to the forum to try just once before you post question.

Really Appreciated.Thank you.

 

[devendra.dvm]

Hi Monty,
Thanks alooot for your help...this userform makes my work easy...got appreciations in my office..all credit goes to you only...really thanks aloot...

Sorry for late reply...went out of station on official work. unable to come to online...

i really appreciate your help...