Macro to Submit And Place

[JaredMcCullough]

Looking for a macro that will combine a command button/inputbox to place data in sequence. First step is use command button for user to "Submit Resposne". This will then initiate some sort of dialog box that allows the user to pick the worksheet and item they want to submit the response for. (Similar to dropdown boxes or data validations I currently use this technique in a VLookup report form) I am not certain if this can be applied to a inputbox or how it would work. The user will then be prompted to input there name and response. Then they will be prompted with checkboxs for it being complete, still open, or declined. So for example They hit "Submit Response" (command button), something comes up which allows them to chose from a 2 staged dropdown the first being a list of worksheets and the second the item (identified in Column A of the worksheet), the user the is given an input box where they put there name and response and hits "OK". This information is the translated to the worksheet to that item number and put in a cell linearly with the row that item number is in (Specifically the corresponding cell in column Q of that worksheet). It hope that is descriptive enough but if need be this can be broken down and worked one step at a time.