W
WLMPilot
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!!!
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!!!