Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have many lines of data and would like to use the input form to recall the
data based on a search so that i can re-enter incorrect data. I have limited VBA experience |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Paul,
When you say "input form" are you actually talking about the gray box type user forms that have text/numeric entry areas on them and maybe a command button that causes the entered information to be put onto a worksheet? If that's the case, you can use that form as a template for another to reverse the operation kind of. I do something similar with a file, and rather than get complicated with searches and such, I have a text entry box at the top of the form that asks for the row number that the information to be edited is in on the sheet. The user enters that number and click a command button, and the code then uses that row number to get the information, kind of like this: Sub CommandGetOldData_Click() Me!textName = ActiveSheet.Range("A" & txtRowEntered).Value Me!txtWage = ActiveSheet.Range("B" & txtRowEntered).Value '... get all of the existing information from a row into the form's text boxes End Sub Then at the bottom, there is another button that when they click it takes all of the information, changed or not on the form, and puts it back onto the worksheet: Sub CommandUpdateWithEdits_Click() ActiveSheet.Range("A" & txtRowEntered).Value = Me!textName.Text ActiveSheet.Range("B" & txtRowEntered).Value = Me!txtWage.Text '...continue replacing old with new End Sub Let me know if I can help any more. "Paul Dye" wrote: I have many lines of data and would like to use the input form to recall the data based on a search so that i can re-enter incorrect data. I have limited VBA experience |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
?-Change data series range as data is entered? | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
UserForm Data to Spreadsheet | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |