VBA - Set time for a specific row using a Button

[TravoG]

Hi All,

Apologies in advance if this question has been asked before. But I ran into a bit of a stumbling block trying to figure this one out.

Scenario,

Assembly\shipping team utilizing a excel spreadsheet to track times of task completions for the assembly\shipping procedure they have in warehouse.

I currently have a button which pulls up a form for easy data\order entry, adds information such as Order#, Customer Name, Due Date, into a table
The table has additional columns such as "pick start time", "pick finish time", "assembly start time" "assembly finish.." and a few more.
I currently have a button that will populate the current time for which ever cell they currently select. End users have to manually ensure that they select the right cell for the current process to work.

I am trying to create a button which will ask the end user a prompt of what order # they are trying to update, and then set the time for that task.

ie. Order# 23456 is already entered in the table, and is about to start being assembled.
The technician assigned to assemble the order selects a button called "Start Assembly"
A prompt opens up, asking what order they are working on, end user has to enter "23456" into prompt
VBA validates that order exists in table, finds the row that the order is on and then updates the "Assembly Start Time" column of the row that order is on.

I don't mind creating multiple buttons for each of the columns being tracked,

I am grateful for any help,

 

[ranman256]

make a user form, with various boxs/combos,
have user use a combo drop box to select what event to do: Start Assy, End Assy, etc
a box for Order#

then you only need 1 button SUBMIT to record the event. instead of N buttons ,1 for each event.