+ Reply to Thread
Results 1 to 4 of 4

Userform is on server - Calculation works on my computer but not on my colleagues computer

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Cape Town, South Africa
    MS-Off Ver
    Office 2013
    Posts
    2

    Post Userform is on server - Calculation works on my computer but not on my colleagues computer

    Hi. I have been struggling to understand why calculations in my userform (a quotation document, I've saved on the server) work perfectly when I do the quote on my computer but give an error on my colleagues computer. She doesn't have any issues opening the userform or selecting the drop down combo boxes to choose the relevant item on the quotation form but as soon as she inserts the required information (her name) into the text box for which I've written some code to automatically calculate the totals for each item, the sub total amount, vat amount and gross amount. The runtime error she gets indicates that the calculations are okay until the final calculation of subtotal + vat amount = grand total.

    Following is the code which I've used to provide the calculation of all the text box values to get a subtotal:

    Please Login or Register  to view this content.

    Following is the code I've used to add the 15% vat amount to the subtotal to get the grand total:


    Please Login or Register  to view this content.
    Many thanks!
    Last edited by Cindib; 05-18-2018 at 05:25 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,237

    Re: Userform is on server - Calculation works on my computer but not on my colleagues comp

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    If posting code please use code tags, see here.

  3. #3
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    952

    Re: Userform is on server - Calculation works on my computer but not on my colleagues comp

    you have no field called: subtotal + vat amount ....
    did you try putting a STOP on the line and see what the values are?

    if all these text boxes are in the form , there should be no errors no matter who runs it.

  4. #4
    Registered User
    Join Date
    05-25-2016
    Location
    Cape Town, South Africa
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Userform is on server - Calculation works on my computer but not on my colleagues comp

    Thanks so much for your feedback. Although everything worked okay on my computer, I thought that I had missed something, hence the reason for it not working on my colleagues computer. Took your advice and then decided to generate a quote on a couple of other computers in the company and the userform calculations were perfect... now to find out why the computer in question is a problem. thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1