'How do I change font size inside VBA next to a .Value?
I wanna change the font size from where I start formatting as hours: Format(Sheet3.Range("F" & TaskRow).Value...
I tried using .Font.Size = 8 on the front, back and inside the code but can't get it to make it work. I am very new to VBA, sorry if this is a stupid question, really tried looking for an answer online.
TaskText = Sheet3.Range("C" & TaskRow).Value & _
vbCrLf & vbCrLf & "De " & Format(Sheet3.Range("F" & TaskRow).Value, "h:mm AM/PM") & " a " & _
Format(Sheet3.Range("G" & TaskRow).Value, "h:mm AM/PM") & _
vbCrLf & Format(Sheet3.Range("D" & TaskRow).Value, "###-###-####")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
