Excel VBA: Display text in textbox from same row different column if ActiveCell.Select

(Problem Solved)

Good afternoon folks

I have a call log tracker that I have somewhat automated. I have 17 columns of data (A:Q) which 16 are used to input contact information. The 17th column (Q) I use to concatenate specific data from the other 16 columns. In Sheet3 (O1) I display my concatenate data using this code (Sheet3.Range("O1").Value = ActiveCell.Value) which is linked to a textbox on Sheet1. Instead of this approach, I would like the textbox to display my concatenate data from the column and row of the ActiveCell.Select. I am having problems figuring out how to this. Any help would be greatly appreciated... Please see my examples below.

Current Configuration:
Call data in cells A1-P1
Q1 concatenates data from A1-P1
Sheet3 (O1) is linked to Sheet1 using Sheet3.Range("O1").Value = ActiveCell.Value
Sheet1/Textbox1 displays concatenated data from Sheet3 (O1)

I would like to have it this way below:
Call data in cells A1-P1
Q1 concatenates data from A1-P1
Sheet1/Textbox1 displays concatenated data based on ActiveCell.Select - I am not sure how to get to this point


I hope I have explained my request well enough .... Thanks again for any assistance!