I want to have a form with two textboxes on it where the first textbox shows the value of the cell in column C for the active row and the second textbox shows the value of the cell in column E for the active row. If I use the Worksheet_SelectionChange event, how do I populate the two text boxes with the content of the two cells from the active row.

If text is typed in one of the text boxes I want the associated cell to be updated. Is it possible to have it so that when text is typed in either the cell or the textbox, the associated textbox / cell is updated immediately. If the associated cell / textbox can't be updated immediately, it will probably be ok for it to be updated when ENTER is pressed.

Also, is it possible to have a shortcut key that switches focus to the form and another one for switching focus back to the spreadsheet?

TIA