Detlef_Lewin Actually, I uploaded that file because I don't know how to do a screenshot and I needed to show an example of the problem. Everything I saw in the spreadsheet was saying each line had the same font but it seems that it was spreading the letters on the 2nd and 3rd line...
Cells(row, notesCol).Value = Me.TextBox1.Value ' Close the userform Unload Me End Sub Add the following code to a new module: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ' Check if the double-clicked cell is in the notes column ...
{"__typename":"ForumTopicMessage","uid":1921073,"subject":"Expanding a set of grouped rows causing excel to freeze/crash","id":"message:1921073","revisionNum":1,"author":{"__ref":"User:user:877469"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ExcelGen...
() ' Get the active row and notes column Dim row As Integer row = ActiveCell.Row Dim notesCol As Integer notesCol = 5 ' Change this to the column number for your notes column ' Set the textbox value to the notes for the active row Me.TextBox1.Value = Cells(row, notesCol).Value...
pageTitledescriptionredirect