Results 1 to 4 of 4

Llistbox Data Edit from Other userform

Threaded View

  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.

    Private Sub cmdClose_Click()
    Unload Me
    End Sub
    
    Private Sub ListBox1_Click()
    If Changeflag = True Then Exit Sub
    Dim say As Long, A As Byte, r As Long
    Dinfo1 = ListBox1.List(ListBox1.ListIndex, 0)
    
    For A = 1 To 6
    
    Next
    
    Sheets("Data").Range("A:A").Find(ListBox1.Text).Activate
    say = ActiveCell.Row
    Sheets("Data").Range("A" & say & ":I" & say).Select
    TextBox1 = ListBox1.ListIndex + 1
    End Sub
    
    
    Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    
    UserForm2.Info1.Text = Me.ListBox1.Column(0)
    UserForm2.Info2.Text = Me.ListBox1.Column(1)
    UserForm2.Info3.Text = Me.ListBox1.Column(2)
    UserForm2.Info4.Text = Me.ListBox1.Column(3)
    UserForm2.Info5.Text = Me.ListBox1.Column(4)
    UserForm2.Info6.Text = Me.ListBox1.Column(5)
    
    UserForm2.Show
    
    End Sub
    
    
    
    Private Sub SaveEdit_Click()
    
    UserForm1.ListBox1.Column(0) = Me.Info1.Text
    UserForm1.ListBox1.Column(1) = Me.Info2.Text
    UserForm1.ListBox1.Column(2) = Me.Info3.Text
    UserForm1.ListBox1.Column(3) = Me.Info4.Text
    UserForm1.ListBox1.Column(4) = Me.Info5.Text
    UserForm1.ListBox1.Column(5) = Me.Info6.Text
    
    End Sub

    Thank you in advance for your help and support

    Kirana
    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. 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