Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 470
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
form that retrieves existing data from table and allows editing John L[_2_] Excel Discussion (Misc queries) 2 October 9th 09 06:32 PM
Imported Data Not Replacing Existing Data - Excel 2007 Marilyn Excel Discussion (Misc queries) 0 April 27th 09 05:22 PM
Excel 2007 / MS Query - editing existing query to another sheet Hotpepperz Excel Discussion (Misc queries) 0 June 13th 08 06:53 PM
Adding data to existing data that has a unique number in column Lars Excel Discussion (Misc queries) 3 June 28th 07 11:48 AM
Editing an existing formula Jen Excel Worksheet Functions 1 October 24th 05 07:55 PM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"