Submit Macro

[Xander1015]

Good afternoon All,

I am attempting to custom create a form that users will input data and then click Submit to save the inputs on a simple table format on another tab. I cannot get past the runtime error 1004 Method 'Range' of Object '_Global' failed. Spelling is correct. Could the location of the Header referenced be an issue? Each of the ranges represent a column of data, but Sheet names, logo, ect are above those columns. the input form changes based on drop down list selection, so I want each selection to be submitted and saved on the other tab so new inputs for a different selection can be entered on the original form. I am fairly new to VBA coding.

 

[KenU]

You need to define the variable next_row in your routine.

Hope that helps.

Regards,
Ken