Filling Comboboxes Based On Value Of One Combobox?

I have 2 combo boxes dependent on one combo box. When I select an item from the dropdown list in ComboBox1, I want the corresponding data attached to ComboBox1 to be available in ComboBox 2 and ComboBox3.

Example:
ComboBox1 ComboBox2 ComboBox3
John Male English

Data for ComboBox1 are in column A2 (Names), data for ComboBox2 are in column B2 (Gender) and data for ComboBox3 are in column C2 (Language spoken).

I chanced upon a code written by royUK from this Excel Forum, which works well for 2 ComboBoxes. This is the code:

Option Explicit
Dim rSource As Range
Private Sub ComboBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

[Code].....