Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Help with Userforms! SGD10

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help with Userforms! SGD10

    Hi all excel experts,

    I have 4 userforms that i have worked on the codes but i am stuck in between for all of them. It would be great if anyone could help me work on this and touch up my codes if possible. If any further clarifications are needed as to what i require, please feel free to comment.

    1) 'SearchContractForm' UserformUser to input contract number then search. Data are in the 'today' sheet. Corresponding values of the row of that contract number must be shown in the other textboxes of the userform. Currently from what i have done, the data doesnt tally accordingly to the headers. And I am only able to search for the first contract number in the 'today' sheet. It doesn't work for the others when tried. There are 2 currencies, SGD and USD, and the net amount are in different columns. If there is no such contract number, msgbox should appear. After able to view the data correctly, if there are any updates to be made, the new values should be in 'UpdatedContracts' sheet and the previous data should not be affected.

    2)'GstForm' Userform
    There are some data in 'GstClients' that are to be vlookup against data in 'today' sheet. I have done the vlookup alr and the results I want is in column S and T. There will be either contract numbers or #N/A. When user clicks show contracts in the userform, it should display contract numbers that are in column T and Column S. Any changes to other cells values in future that results a change in Column S and T, the userform should still be able to display the new values.

    3)'NewClientForm' Userform
    I am able create client code and client name and the values appear in the "GstClients" sheet as desired. However, i want it to have msgbox when either one of the textbox is empty. And also client code should be integers always, else msgbox to inform user. When created, msgbox should appear. Wherever necessary, please include msgboxes or whatever is necessary in a basic creation userform.

    4) 'CalculateGst' Userform

    For record type Buy: Sett amount = Net amount - GST
    For record type Sell: Sett amount = Net amount + GST

    Able to search for contract number and display net amount, record type, currency, sett currency. Somewhat similar to 2) for the searching part. When user inputs the GST value and clicks calculate, sett amount should be calculated based on above formula and be displayed in the userform. If user decides to click update button, the values should be updated to the "UpdatedGst" sheet.

    Thats all I need help in. Hope someone will be able to look into this and help me out. Payment has been made. Transaction ID: 3DK58633R7721435V

    Thank you.

    Hxz
    Attached Files

  • #2
    Re: Help with Userforms! SGD10

    I can look at this for you.
    We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

    Comment


    • #3
      Re: Help with Userforms! SGD10

      Thanks a lot! Much appreciated.

      Comment


      • #4
        Re: Help with Userforms! SGD10

        In the first user form what is "Security Code"? there is no column in the "today" sheet with that heading.
        We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

        Comment


        • #5
          Re: Help with Userforms! SGD10

          That can be deleted. I forgot to remove it.

          Comment


          • #6
            Re: Help with Userforms! SGD10

            OK, thanks.
            We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

            Comment


            • #7
              Re: Help with Userforms! SGD10

              File sent more than a week ago, no payment for the agreed amount yet received. Please make the payment via PayPal with the ID I sent you.

              Thanks.
              We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

              Comment

              Trending

              Collapse

              • maichal
                auto generate id in user form save sale purchase data on sale & purchase sheet
                maichal
                i am add add sale transaction & add purchase transaction command button & the id was Auto generate in text box 1 if i am choose sale in combo box 1 than sale-001 id was Auto generate in text box 1 add the name in combo box 2 & click on add sale transaction command button the data was add on the sale sheet,if i am choose Purchase in combo box 1 than Purc-001 id was Auto generate in text box 1 add the name in combo box 2 & click on add Purchase transaction command button the data was add on the Purchase sheet, please solve this sir, after add the information in sale & purchase excel sheet, i am choose sale in combo box 1 the id was auto generate in id text box 1, than i am choose the name in combo box 2, if i am choose sale in combo box 1 than combo box 2 show only sale Customer...
                2 days ago
              • DiogoCuba
                US$20 to Automate Crew Roster
                DiogoCuba
                Hi, I have a Crew Roster that controls the crew changes of a certain vessel and I would like to automate it to avoid wasting time with manual copy and paste.

                Anybody willing to help me?

                Some of the actions I need:
                • Create a Pax list and a Flight Manifest based on the personnel assigned to embark and disembark;
                • Generate a Daily POB based on the names that are onboard (Including the dates of embark and a counter to count how many days the person is onboard);
                • Compare the Daily POB to a criteria to see if the safe manning is compliant or not;
                • Create a PAX LIST for the next 7 days automatically so that I can see who is crew change and who is not - this should be triggered based on the dates;
                • Auto generate Flight Manifest when I click a button and input the
                ...
                June 27th, 2017, 09:47
              Working...
              X