There have been many posts about trying to scroll through validation, ComboBoxes,ListBoxes, the usual end result when somebody tries this is that XL ends up freezing.
To add additional Text to a cell, you could try.
or![]()
Range("C7") = Range("C7") & ", How are you?"
Or if you wanted another line added to the cell![]()
Range("C7") = Range("C7") & " " & TextBox1
![]()
Range("C7") = Range("C7") & Chr(10) & " " & TextBox1
Bookmarks