Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Textboxes
I currently have a macro that will allow the user to enter
in a piece of information, will find that information on the spreadsheet, open up a form listing that information (and some other stuff) and allow the user to edit the information. Ideally, when the OK button is hit, the now edited information will be saved back into the correct cells. I cannot get the information to go back to those cells. Suggestions? Thanks Pat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Textboxes
Just use the same information the user entered to find the information to again "find that information on the spreadsheet," Then use that range as the basis for writing back the information. set rng = Cells.find(textbox1.text) rng.offset(0,1).Value = Textbox2.Text rng.offset(0,2).Value = Textbox3.Text -- Regards, Tom Ogilvy "Pat" wrote in message ... I currently have a macro that will allow the user to enter in a piece of information, will find that information on the spreadsheet, open up a form listing that information (and some other stuff) and allow the user to edit the information. Ideally, when the OK button is hit, the now edited information will be saved back into the correct cells. I cannot get the information to go back to those cells. Suggestions? Thanks Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textboxes | Excel Discussion (Misc queries) | |||
UserForm TextBoxes | Excel Discussion (Misc queries) | |||
tab between several textboxes | Excel Worksheet Functions | |||
Excel Textboxes | Excel Programming | |||
userform textboxes | Excel Programming |