+ Reply to Thread
Results 1 to 7 of 7

runtime error 70 when try to add item to listbox

  1. #1
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    runtime error 70 when try to add item to listbox

    Hi,


    pls go through the below mentioned code.

    Please Login or Register  to view this content.
    pls help


    thank you in advance


    regards
    shiva
    Last edited by Fotis1991; 02-03-2017 at 04:38 AM. Reason: PLS USE CODE TAGS.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: runtime error 70 when try to add item to listbox

    Can you post example file for testing?

    Most likely RowSource is set on initializing.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    Re: runtime error 70 when try to add item to listbox

    Hi bakerman2,


    Pls go through the userform in attached excel file.

    "Add New Genre" Code is not working.


    regards
    shiva
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    Re: runtime error 70 when try to add item to listbox

    Hi bakerman2,


    Pls go through the userform in attached excel file.

    "Add New Genre" Code is not working.


    regards
    shiva
    Attached Files Attached Files

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: runtime error 70 when try to add item to listbox

    No file attached so far.

  6. #6
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    Re: runtime error 70 when try to add item to listbox

    Hi bakerman2,


    Pls go through the userform in attached excel file.

    "Add New Genre" Code is not working.


    regards
    shiva

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: runtime error 70 when try to add item to listbox

    Remove the RowSource from the ListBox properties and add following code.

    Please Login or Register  to view this content.

+ 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. [SOLVED] Userform listbox adding rowsource runtime error 380
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2016, 02:10 PM
  2. [SOLVED] Listbox item not rounding to 2 decimals - Runtime error 13 Type mismatch
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2016, 09:18 AM
  3. listbox runtime error 13 type mismatch
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2015, 02:27 AM
  4. runtime error on listbox click
    By kmakjop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2015, 09:17 AM
  5. Run Time Error when Deleting last Item in ListBox
    By gunsmith01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2014, 03:05 AM
  6. Replies: 1
    Last Post: 11-17-2012, 11:10 PM
  7. Runtime Error Listbox
    By matthew290683 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2012, 01:58 AM

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