Results 1 to 9 of 9

getting type mismatch using list listindex

Threaded View

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    getting type mismatch using list listindex

    this used to work, but i must have done something to make it stop. not sure what it is.

    when i run the button on the addvendor sheet and type in the search box, all appears to be fine. but when i pick the item in the listbox, i get a type mismatch 13, run time error on this line:

    tb_Name.Value = sht.Cells(.List(.ListIndex, 1), 4)
    when i type this in the immediate window, i get the same error: ?sht.Cells(.List(.ListIndex, 1), 4)

    i checked the sht.name and it is correct. i checked the activesheet.name and it is correct.

    what did i do wrong in the code to make this stop working?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Get additional matching selection from combo box .List(ListIndex)
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2017, 07:00 PM
  2. Run Type error 13 Type Mismatch
    By Affan Khan in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-13-2012, 12:58 PM
  3. [SOLVED] Iterate Through Names, list unused: Type Mismatch with Cells.Find
    By tlafferty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2012, 04:03 PM
  4. [SOLVED] Run-type error 13 type mismatch
    By misop in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-05-2012, 04:08 AM
  5. Type Mismatch: array or user defined type expected
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2006, 10:45 AM
  6. Type mismatch using rnge as Range with Type 8 Input Box
    By STEVE BELL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2005, 01:10 AM
  7. Help: Compile error: type mismatch: array or user defined type expected
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 05: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