Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup values in textbox and edit row
My previous post may have been confusing (at least to myself)
Basically I have 2 sheets "Edit" and "Data" The "Data" sheet looks like this Name Number Status Mark 564 Active John 231 Inactive Bill 789 Active If a user types John into a textbox("tbfindname") in the sheet "Edit" and clicks a command button("CBFindName") I would like my 3 other text boxes tbname, tbnumber and tbstatus to display John, 231, and Inactive. After that if the user changes John's status to Active I would need another command button that would change the "Data" sheet to reflect the change in the textbox. Name Number Status Mark 564 Active John 231 Active Bill 789 Active Please Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you edit the text in a userform-textbox? | Excel Programming | |||
Vlookup doesn't work until i edit(but not change) the lookup cell | Excel Worksheet Functions | |||
Textbox edit | Excel Programming | |||
Edit Excel TextBox using C# | Excel Programming | |||
Edit Textbox using KeyPress vba code in Access | Excel Programming |