+ Reply to Thread
Results 1 to 3 of 3

Type mismatch in VBA

  1. #1
    Registered User
    Join Date
    02-18-2023
    Location
    Kuala Tanjung, Indonesia
    MS-Off Ver
    2019
    Posts
    17

    Type mismatch in VBA

    Hi, I face a problem when executing a vba that i try to develop from another user from my last post.
    snap.PNG

    Guide for Suffering.xlsm

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: Type mismatch in VBA

    hover over highlighted error - you will see you have used 'ceS' as a column reference whereas it is in fact a range - I do not follow the logic of the code ????
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  3. #3
    Registered User
    Join Date
    02-18-2023
    Location
    Kuala Tanjung, Indonesia
    MS-Off Ver
    2019
    Posts
    17

    Re: Type mismatch in VBA

    In guide sheet, I want the troubleshoot column shown when the equipment type and problem is chosen and the value of troubleshoot chosen from the nemo sheet or teikoku sheet or centrifugal sheet, depends on which equipment and problem is choose in "Guide" sheet. But when i try to create the vba, it shows error as shown above. How to fix that?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. [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
  3. 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
  4. Type Mismatch
    By Abode in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2006, 07:35 PM
  5. 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
  6. [SOLVED] Type mismatch !
    By Roshintosh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-10-2005, 03:15 PM
  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

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