Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing existing data
I have created a supply request order form that uses inputboxes and userforms
to obtain info for each item, ie (Item# and Qty). The description is pulled from another sheet (same workbook) depending on Item# entered. I want to have a way for the user to edit an incorrect entry via clicking a commandbutton, then use a userform to pull the incorrect data in and then correct it. In writing this question, the wheels started turning with questions like "What if the user originally entered the same item number twice?" So now I guess I have two questions: 1) When the user first enters data for the supply request, is there a way to remove the item number from the combobox (created each time the "ENTER" command button is clicked on the userform). The item numbers for the combobox are pulled from the sheet("Items"). 2) Now back to the original question: Once the user clicks "EDIT" commandbutton and the item number is entered for the line-item that contains the incorrect Item number or Quantity, what is the code that looks on the worksheet and finds the data that needs to be corrected? I have two "forms" (if you will) due to page restrictions that are used to display the item information once the user enters the original order: ITEMNUM: A13-A50 and G13-G50. QTY: B13-B50 and H13-H50 Description: C13-C50 and I13-I50 (this field is automatically entered into form based on the item number. Thanks for your help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form that retrieves existing data from table and allows editing | Excel Discussion (Misc queries) | |||
Imported Data Not Replacing Existing Data - Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Editing an existing formula | Excel Worksheet Functions |