We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Add data via Userform

Cartillo
Cartillo asked
on
Medium Priority
406 Views
Last Modified: 2012-05-11
Hi Experts,

I would like to request Experts help  add an additional function In the attached script to allow data update (edit/delete) from Userform into target cell at Column J and K. Currently the Userform only can display the detail of the cells content by double click at column J or K cell. Hope Experts will help me to create this feature.



Private Sub UserForm_Initialize()
With Me.TextBox1
    .WordWrap = True
    .MultiLine = True
End With
With Sheets("Daily Tracking List")
    Me.TextBox1.Value = "Issues: " & .Cells(Selection.Row, "J") & vbCrLf & vbCrLf & _
        "Findings/Updates: " & .Cells(Selection.Row, "K")
End With
End Sub

Open in new window

DataEntry.xls
Comment
Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Hi Sid,

Yes, but its only updates column K, can we have similar control for column J?

Author

Commented:
Hi Sid,

Sorry for the wrong update..it works perfectly.

Author

Commented:
Thanks a lot Sid...
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.