Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Help with Userforms! SGD10

  1. #1
    Join Date
    26th December 2016
    Posts
    3

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  2. #2
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

    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

  3. #3
    Join Date
    26th December 2016
    Posts
    3

    Re: Help with Userforms! SGD10

    Thanks a lot! Much appreciated.

  4. #4
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

    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

  5. #5
    Join Date
    26th December 2016
    Posts
    3

    Re: Help with Userforms! SGD10

    That can be deleted. I forgot to remove it.

  6. #6
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

    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

  7. #7
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. vba.userforms
    By Clampflower in forum Excel General
    Replies: 1
    Last Post: August 2nd, 2011, 19:06
  2. VBA and Userforms
    By leithm in forum Excel General
    Replies: 1
    Last Post: August 16th, 2010, 14:17
  3. Userforms
    By lche90 in forum Excel General
    Replies: 1
    Last Post: April 21st, 2007, 16:18
  4. Userforms
    By abbeville in forum Excel General
    Replies: 4
    Last Post: May 10th, 2005, 05:00
  5. Userforms
    By abbeville in forum Excel General
    Replies: 7
    Last Post: April 29th, 2005, 19:21

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno