Hi all,

I am wanting to use the answer a user provides from an input box and place it in a specific place within a cell's text. For example:

 
Dim date1 As String, Set a = Range("C6")
date1 = InputBox("Please enter the effective date of the plan change.", "Date:")

a = The plan is effective on "date1".

Obviously the above code doesn't work, but I'm not able to find any information to take the information the user provides in the answer and refer to it within code. I can use "date1", but the information the user types in for "date1" does not display in cell c6. It just says: "The plan is effective on date 1."

Any help is appreciated. Thank you.