+ Reply to Thread
Results 1 to 3 of 3

Type Mismatch-calculating textbox values from different multipage tabs

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    63

    Type Mismatch-calculating textbox values from different multipage tabs

    I'm sure this is easy for some of you, but I just can't figure it out! I keep getting a type mismatch when I try to calculate the product of two text boxes, each from a different tab on a multipage userform. Here's my code:

    Please Login or Register  to view this content.
    Where allocations 1 and 2 are percentages (%) entered in on one multipage sheet, and the amount ($) is on another multipage sheet (named InvoiceInfo) of the same userform. I want to get the product of these, but I keep getting type mismatch error! Please help! Many many thanks in advance!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Type Mismatch-calculating textbox values from different multipage tabs

    Can you post a workbook with some numbers I can step through and test?
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-27-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Type Mismatch-calculating textbox values from different multipage tabs

    inv appr xl help.xlsm



    I have commented out some of the things that aren't working.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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