[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Add data via Userform

Posted on 2011-04-23
4
Medium Priority
?
397 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
0
Comment
Question by:Cartillo
  • 3
4 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 2000 total points
ID: 35453028
Like this?

Sid
DataEntry.xls
0
 

Author Comment

by:Cartillo
ID: 35453110
Hi Sid,

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

Author Comment

by:Cartillo
ID: 35453114
Hi Sid,

Sorry for the wrong update..it works perfectly.
0
 

Author Closing Comment

by:Cartillo
ID: 35453115
Thanks a lot Sid...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question