Macro to Submit And Place

JaredMcCullough

Well-known Member
Joined
Aug 1, 2011
Messages
516
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.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,477
Members
414,070
Latest member
DuncanLucas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top