Command button code that fills two combo box values and a toggle in cell

Hi it is actually like this:

I have to cells with data validation list=...
Then I have one toggle button that can have value Y or N.

Now, I am looking for a command button code that fills both three values into a cell range that I select with the mouse. Result is merged.

Choice 1 = Paris
Choice 2 = Car
Driver? Yes

Push button, asked for cell range then result:

Cell B1 - B5:
Paris Car Y

Bart

Hi Pike, I have attached. The explanation is inside.

with the previous code (with comboboxes) it worked fine, you can still see two samples

I only wants to have the values from the Validation=list cells rather then comboboxes

Hi Pike, thanks it works. I can fine tune when I know more about the solution you give me.

Two questions about text position:

You used " " for a space. What is the "enter" code, so the contents goes to the second line of the cell range? I tried to find in the VB Help but failed to get the understanding.

Sample:

Text A
Driver Text B Beamer

Possible to use align commands so text is placed either "centered", then on second line "left" / "centered" / "right"?

Understood.

The merged cells contents is from two cell values D3 and H3.
Possible to replace the value for the last with the value that is asked by the user? (Same as: "Select A Range", but now "What is your location?" (input limited to 15 characters).

Btw, If I cancel the current "Select A Range" question then I get an VB error. I need an Ifthen statement as far as i know.

Yes, that basically work, but it makes the sheet very high as there are many employees (you can unhide the rows).

I am still looking for user input question solution as not all values can be listed using validation/list.

Btw, canceling the current Range selection question gives an error.