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

userform

hi team
Pls help me...pls create vba userform for data entry...i need to configure commission rates for agents..pls the refer attachment for the same.
 

Attachments

  • User Form.xlsx
    71.4 KB · Views: 10
Step one: 1 this is my instruction right.

upload_2017-2-12_23-57-12-png.38413




step2: I will configure rates for MM scheme and two agents
so i will pest that agents in apply agents box and i will update rates and other fields in form and i will hit enter
upload_2017-2-12_23-59-47-png.38414



Step 3: After hitting enter out put will be like this for first two agents and for first schemes below image
upload_2017-2-13_0-3-6-png.38416

Step4: nest i will configure rates for second condition in instruction
for scheme FS and 3rd and 4th agents... so i will paste these agents codes in apply agents

upload_2017-2-13_0-5-29-png.38417
 
upload_2017-2-13_0-11-48-png.38418


and i will update rates as per instruction for FS scheme and 3rd & 4th Agents and i will hi apply agents.. and output will get export next to "MM" scheme out put as highlighted in below pic

upload_2017-2-13_0-20-8-png.38420


i will repeat same steps for remaining schemes "TR and W2" and agents as per instruction.

upload_2017-2-13_0-25-23-png.38422


and output get export next to MM and FS schemes output as shown in below pic
upload_2017-2-13_0-34-24-png.38424


after completing all schemes and agents i will hit finish button and output will be like this as shown in below pic

upload_2017-2-13_0-35-46-png.38425
 
Note:
Broke Type(No Limit as there are more broke type id's I will use as per instructions)
Agents ( No limit)
Scheme ( No Limit)
From amount(No Limit)
To amount(No Limit)
From Month and ToMonth (No limit for days)
 
hi vletm..

thanks for ur help...but my requirement is like this...still m searching n trying for the same...want to check with others also for the same..
 
Hello Devendra.

Please find below quick screenshot of your form.

Let's go by step by step.

1) When you click on Upload what should happen?
2) on dates are you looking for auto date or user will select date?
3) which are the fields user is not supposed to enter which will automatically should populate.

Excel attatched!




upload_2017-2-14_0-45-55.png

Hope you like this!
 

Attachments

  • User Form (1).xlsb
    78.6 KB · Views: 13
1: once i hit upload output should get export into output sheet
2: dates i will update
3: except agent all fields will update user only....that all fields will should get applied to those agents which are mentioned in apply agents
 
upload_2017-2-15_1-32-24.png

create two tables as shown in pic total agents and apply agents

after updating all fields i will mentioned agent codes in apply agents table then i will hit upload button and all updated fields get applied to thos agents and result will get export into output file
 
i will do this for different different schemes repeatedly until unless i hit exit button all updated results should get export to output sheet one after other
 

Attachments

  • upload_2017-2-15_1-36-39.png
    upload_2017-2-15_1-36-39.png
    31.2 KB · Views: 4
Back
Top