Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Forms to Update Worksheet Data
Thanks in advance for the feedback and sorry to those who read it in general
questions. I have VBA form that I've created to display data to the screen using the following code (code only shows of few of the columns of data being loaded to form). Public Sub LoadLongInfo3(ByVal selectedProject As String) Dim databaseRow As Long Set reportsSheet = Sheets("Reports") Set resultsSheet = Sheets("Results") Set devdataSheet = Sheets("DevData") 'Find DataRows To Be Loaded Into Form devdataSheet.Activate devdataSheet.Cells.Find(What:=selectedProject, After:=devdataSheet.Cells(1, 1), LookIn:= _ xlFormulas, LookAt:=xlPart, SearchOrder:=xlByColumns, _ SearchDirection:=xlNext, MatchCase:=True).Activate databaseRow = ActiveCell.Row 'Load Data Into Form lblConcept.Caption = devdataSheet.Cells(databaseRow, 5) lblCity.Caption = devdataSheet.Cells(databaseRow, 7) lblDevName.Caption = devdataSheet.Cells(databaseRow, 2) lblMasterPlan.Caption = devdataSheet.Cells(databaseRow, 10) lblSubmarket.Caption = devdataSheet.Cells(databaseRow, 8) lblRegion.Caption = devdataSheet.Cells(databaseRow, 9) lblTBM.Caption = devdataSheet.Cells(databaseRow, 16) lblTBColRow.Caption = devdataSheet.Cells(databaseRow, 17) lblZip.Caption = devdataSheet.Cells(databaseRow, 18) lblLocation.Caption = devdataSheet.Cells(databaseRow, 19) End Sub To update the data I currently simply go to the datasheet and work my way around it changing cells as need, however there are over 150 columns on the sheet. Is there a way I can nodify this code to edit rows on the orignial source datasheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add/Update data stored in another worksheet | Excel Programming | |||
Excel Data Entry Forms (Data, Worksheet) | Excel Discussion (Misc queries) | |||
VBA: Update worksheet when txtBox data changes. | Excel Worksheet Functions | |||
VBA: Update worksheet when txtBox data changes. | Excel Programming | |||
VBA: Update worksheet when txtBox data changes. | Excel Worksheet Functions |