UserForm with a ComboBox for Row and another for Column

Hi Guys,

I'm getting stuck here trying to create a UserForm to edit dates.
I have a SpreadSheet for recording various expiry dates for different people. Here's a rough idea of what it looks like:

NAME LICENSE-1 LICENSE-2 LICENSE-3
Jack DD/MM/YY DD/MM/YY DD/MM/YY
Jill DD/MM/YY 12/12/2018 DD/MM/YY
Joe DD/MM/YY DD/MM/YY DD/MM/YY
Jane DD/MM/YY DD/MM/YY DD/MM/YY

I'm trying to create a UserForm with 2 ComboBoxs, one that selects the Name and another the License, brings up the current value in a Text Box that is editable. And once updating in the Text Box, clicking an Update button that would update the spreadsheet. Example: ComboBox1: Jill ComboBox2: License-2 TextBox: returns 12/12/2018

So far I've only been able to make a form that updates a row with one combobox to select the name and textboxes for each license value. But haven't been able to select a particular column. Maybe i'm looking at this problem the wrong way.

Thanks for any insight.

asnamara

Brilliant, Thanks very much nyatiaju, exactly what I was looking to do. Just working on a way to dynamically get the column headers which are not numbered but words.