1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

userform

Discussion in 'VBA Macros' started by devendra.dvm, Feb 14, 2017.

  1. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    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.

    Attached Files:

  2. Derek McGill

    Derek McGill Active Member

    Messages:
    130
    Design it your self and you will get help with code to get it to work.
  3. devendra.dvm

    devendra.dvm Member

    Messages:
    148
  4. Monty

    Monty Well-Known Member

    Messages:
    833
    devendra

    Please let us know which fields you are looking for on userform and what action...
    devendra.dvm and Arpanakumar like this.
  5. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    hi monty

    thanks for the reply...pls check the attachment..have mentioned the requirements
  6. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    Step one: 1 this is my instruction right.

    [​IMG]



    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
    [​IMG]


    Step 3: After hitting enter out put will be like this for first two agents and for first schemes below image
    [​IMG]
    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

    [​IMG]
  7. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    [​IMG]

    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

    [​IMG]

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

    [​IMG]

    and output get export next to MM and FS schemes output as shown in below pic
    [​IMG]

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

    [​IMG]
  8. vletm

    vletm Well-Known Member

    Messages:
    2,763

    Attached Files:

  9. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    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)
  10. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    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..
  11. Monty

    Monty Well-Known Member

    Messages:
    833
    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!

    Attached Files:

  12. Arpanakumar

    Arpanakumar Member

    Messages:
    88
  13. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    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
  14. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    please create two tables as shown in below pic...

    [​IMG]

    not limit for agents
  15. Monty

    Monty Well-Known Member

    Messages:
    833
    devendra

    Your uploading part is done!


    Hope you like this!

    Attached Files:

  16. Monty

    Monty Well-Known Member

    Messages:
    833
    Let me know what next!

    Am unable to see your screenshots(Pics)
    Last edited: Feb 14, 2017
  17. Monty

    Monty Well-Known Member

    Messages:
    833
    Devender...No response form you, am going for a tight sleep it was really hectic at office today!:);):(:mad::confused::cool::p:DD:eek::oops::rolleyes:o_O
  18. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    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
  19. Monty

    Monty Well-Known Member

    Messages:
    833
    devendra

    Looks like it's :mad:order to forum members.

    First check the file attatched! and let us know what are the challenges then we can proceed to your next steps!
  20. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    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

    Attached Files:

  21. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    sorry pls ignore grammer mistakes...its not order consider as request
  22. Monty

    Monty Well-Known Member

    Messages:
    833
    Hello devendra

    R u sleeping or me!

    Read my messages first and put your questions later!

    Sorry i need to stop here!
  23. Monty

    Monty Well-Known Member

    Messages:
    833

    Did you check this?
  24. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    sorry monty dont mind...network problem
  25. devendra.dvm

    devendra.dvm Member

    Messages:
    148
    fine uploading part perfect

Share This Page