Results 1 to 6 of 6

Runtime error '13' type mismatch when posting userform entries to excel table

Threaded View

Deventre Runtime error '13' type... 01-28-2016, 07:25 AM
TMS Re: Runtime error '13' type... 01-28-2016, 07:44 AM
Deventre Re: Runtime error '13' type... 01-28-2016, 09:27 AM
TMS Re: Runtime error '13' type... 01-28-2016, 09:46 AM
Deventre Re: Runtime error '13' type... 01-28-2016, 11:29 AM
TMS Re: Runtime error '13' type... 01-28-2016, 11:32 AM
  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    5

    Unhappy Runtime error '13' type mismatch when posting userform entries to excel table

    Hi All.

    I am new to the forum (although I have received ample help as an "incognito" before).

    I have an Excel table which acts as a repository of various data types and gets populated through an Userform.

    The posting of the data, through a button, worked perfectly up until I meddled with the formatting of the individual fields in the table. Now I get a" Runtime error '13', type mismatch" at the code line where the Userform data are assigned to the fields in the table.

    The code I have used, without any problems, did not have variables declared, thus not all entry data types were correct i.e. some numerical values were entered as text due to the default Variant type etc.

    I have subsequently declared variable types according the combobox and textbox entries, but still resulting in same error. I'm running Office2013.

    Any help will be appreciated. Thanks
    Last edited by Deventre; 01-28-2016 at 11:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Runtime error 13 type mismatch in Excel VBA
    By Juggler_IN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2015, 09:07 AM
  2. Runtime Error 13 type mismatch
    By Gauravsinghp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2014, 06:23 AM
  3. [SOLVED] Excel VBA Runtime Error 13 - Type Mismatch
    By mook25 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2013, 07:30 AM
  4. RunTime Error 13 and Type Mismatch...
    By TheNewGuy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2010, 09:24 AM
  5. runtime error 13 type mismatch
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2009, 11:15 PM
  6. Runtime Error 13 - type mismatch
    By hindlehey in forum Excel General
    Replies: 1
    Last Post: 11-07-2005, 10:55 AM
  7. [SOLVED] Runtime Error '13': Type mismatch
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2005, 03:06 PM

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