Announcement

Collapse
No announcement yet.

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

              Working...
              X