+ Reply to Thread
Results 1 to 4 of 4

Llistbox Data Edit from Other userform

  1. #1
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    204

    Llistbox Data Edit from Other userform

    Please help

    I am trying to update the data by clicking the Listbox,but getting error,
    "Run time error 70 could not set the column property permission denied"
    Below is code in which I am getting this error.

    Please Login or Register  to view this content.

    Thank you in advance for your help and support

    Kirana
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Llistbox Data Edit from Other userform

    When i see a "permission denied" error, the first thing I do is go to the controls properties to see how the control is populated,
    You have the ListBox populated using the properties box "RowSource" ="information"
    If you delete "information" from the ListBox properties and add a code in the userform_initialize event, you probable will not get the "Permission error"

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    204

    Re: Llistbox Data Edit from Other userform

    Hello Davesexcel,

    is not working I get "Runtime Error 91:-Object variable or with block variable not set"

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Llistbox Data Edit from Other userform

    It would help if you mentioned where this error occurs

+ 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. UserForm to Edit Data
    By DomSza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2015, 08:05 AM
  2. How to update data's by using VBA userform also edit by Sl. No
    By Nisar.mohammed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2015, 10:38 AM
  3. UserForm : i need a userform to add data, delete data, edit data
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 01:59 AM
  4. Populate data in userform and edit
    By surajitbose in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2012, 04:51 PM
  5. Edit Data through UserForm
    By sgp in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-13-2011, 06:04 AM
  6. Edit worksheet data thru userform
    By LoveCandle in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-06-2009, 12:06 PM
  7. Userform to edit data
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2008, 07:27 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