Results 1 to 7 of 7

runtime error 70 when try to add item to listbox

Threaded View

  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.

    Private Sub cmdnewgener_Click()
        If newgener.Value <> "" Then
       generlst.AddItem newgener.Value  ----> error 70 - permission denied
            Sheet2.Range("a12").End(xlDown).Offset(1, 0).Value = newgener.Value
          
            newgener.Value = ""
        End If
    End Sub
    pls help


    thank you in advance


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

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