Results 1 to 6 of 6

Run-Time Error ‘13’: Type Mismatch in Userform

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    Run-Time Error ‘13’: Type Mismatch in Userform

    Dear Expert,

    Below mentioned code is on a User form Text box Named as “Qty”:

    In the Below Code:-

    Qty, C_LL, UOM_MM are a Text Boxes contains some value given by a user.

    F_Qty is a another textbox, based below logic I would want a Result. But when I execute the same. Getting an subjected Error, Kindly help me to amend the code which gives desired result!


    Private Sub Qty_AfterUpdate()
    If C_LL > 0 And UOM_MM = "M" Then
        F_Qty.Value = Round((C_LL.Value * Qty.Value) / 1000, 0)
    Else
       F_Qty.Value = Qty.Value * 1
    End If
    End Sub
    Thanks & Regards,
    Rajeshkumar R
    Last edited by Rajeshkumar R; 10-21-2017 at 12:45 AM. Reason: Query Resolved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Type Mismatch Error Populating a userform
    By Mack1981 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-24-2017, 07:40 PM
  2. Run-time error ‘13’: Type mismatch on Userform textbox if empty
    By dentler in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2017, 03:37 AM
  3. Type mismatch error in userform
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-11-2016, 09:29 PM
  4. [SOLVED] Run time error 13 - Type mismatch
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2013, 08:30 AM
  5. Run-Time error 13 type mismatch - HELP
    By clundeen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2013, 04:23 PM
  6. [SOLVED] Passing Userform Listbox to sub causes type-mismatch error
    By Kleev in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2005, 04:05 PM

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