I'm trying to set up a userform with three comboboxes that would each be
populated by one of two range names.
cbo_PYear by "Year"
cbo_CYear by "Year"
cbo_State by "States"

Upon clicking a button to start the spread sheet I need the form to be
visible and to collect the user information and when the user clicks OK for
it to send the values to another range name.
Does anyone know how I would set the code up for this?

Private Sub Userform_Go()

End Sub