Report Card Cpmment Creator Help

[TheChristige]

Hello big brain excel experts.

I am a middle school teacher who is trying to design a dynamic comment creator for my report cards that allows me to select from a pool of different comments and have them combine into a larger comment.

I can accomplish this slowly at the moment by clicking my comment cell and using the =text&text&text formula but that is clunky and slower than I would like it to be. I can record macros but don't know enough VBA to be able to do this properly in VBA. If you could help me out or even just tell me what things I can look up to teach myself to do this because I don't even know what VBA code to Google to accomplish this. I'm looking to be able to click the sample text or a button beside each option to have it all conglomerate into one larger comment.

Here is an image of my table so far. The red is the name of the students or the adjective I fill in based on their current grade.

 

[Joe4]

Welcome to the Board!

See if something like this simple VBA code will work for you (or at least give you some ideas).
Simply select all the comments you wish to include (using CTRL+click on the cells you want to select a multi-cell range).
Then run the code below, which will prompt you for the address to paste the combined result in:

Sub MyCombineComments()

    Dim dest As String
    Dim cell As Range
    Dim str As String
    
'   Prompt them to enter address of cell to place output in
    dest = InputBox("What is the address of the cell you wish to paste the results in?")
    
'   Combine selections
    For Each cell In Selection
        str = str & cell.Value & " "
    Next cell
    
'   Paste results in designated cell
    Range(dest) = str
    
End Sub

 

[TheChristige]

This was perfect, thank you so much!

 

[Joe4]

You are welcome.
Glad I was able to help!