Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a userform that allows a person to enter information into several
textboxes and output the information into a worksheet. Is there a way that i could edit the information already put into the spreadsheet by searching for a number and then recalling all the information for that number into the userform? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If your data is in a contiguous table format w/column headings you might want
to consider using the built-in form accessed by clicking DATA and selecting FORM. You'll want to move the cell pointer to a location in the table before selecting the menu items. It would certainly save you a great deal of coding. -- Kevin Backmann "enyaw" wrote: I have a userform that allows a person to enter information into several textboxes and output the information into a worksheet. Is there a way that i could edit the information already put into the spreadsheet by searching for a number and then recalling all the information for that number into the userform? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This would work fine Kevin but I need the information brought back to the
userform because there are calculations done on the userform before the info is pasted. I would also need to overwrite the existing data when i am finished editing. "Kevin B" wrote: If your data is in a contiguous table format w/column headings you might want to consider using the built-in form accessed by clicking DATA and selecting FORM. You'll want to move the cell pointer to a location in the table before selecting the menu items. It would certainly save you a great deal of coding. -- Kevin Backmann "enyaw" wrote: I have a userform that allows a person to enter information into several textboxes and output the information into a worksheet. Is there a way that i could edit the information already put into the spreadsheet by searching for a number and then recalling all the information for that number into the userform? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Automatically update cells | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
Update links prompt not wanted | Excel Discussion (Misc queries) |