Forum

Notifications
Clear all

Text Box Character Limit when referencing a cell

6 Posts
4 Users
0 Reactions
231 Views
(@bagallagher)
Posts: 6
Active Member
Topic starter
 

Is there a way to get around the 255 character limit in a text box that uses a cell reference? Ideally without having to use ActiveX controls, but any suggestions are welcome! 

 
Posted : 07/04/2020 10:42 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Brian,

I'm not aware of any workaround, sorry.

Mynda

 
Posted : 07/04/2020 8:00 pm
(@bagallagher)
Posts: 6
Active Member
Topic starter
 

Hi Mynda,

Thanks for looking into this. I think as a workaround I can simply use in-cell text, and move away from the text boxes. This leads me to another question - is there a way to manage the height of a row, based on the character length in a cell? Possibly a VBA application ...

Thanks again,

Brian

 
Posted : 08/04/2020 12:03 pm
(@purfleet)
Posts: 412
Reputable Member
 

Somthing like the below?

Sub LenRowHeight()

Dim r As Range
Dim c As Variant

Set r = Range("a:a")

For Each c In r
If Len(c) > 10 Then
c.EntireRow.RowHeight = 50
End If
Next c

End Sub

 
Posted : 08/04/2020 4:38 pm
(@bagallagher)
Posts: 6
Active Member
Topic starter
 

Thanks - will give this a try - I am very novice with my VBA but we have others on my team that could help - I'll let you know how it turns out.

Very much appreciated! 

 
Posted : 09/04/2020 9:29 am
(@debaser)
Posts: 837
Member Moderator
 

If you're using VBA you could just use the code to populate the text box.

 
Posted : 15/04/2020 9:49 am
Share: