Cell auto filled with dots

Solved/Closed
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
- Jun 16, 2014 at 04:49 PM
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
- Jun 19, 2014 at 07:27 PM
Hello,
I sow it once but not sure where and can't work out how to do it.
Basically, if I write things in excel, I need it to be auto filled with dots so that no space is left in the cell. I hope it is clear, but please let me know otherwise. I know it can be done because I've seen it before but didn't take a note at the time regretfully. Much appreciated

3 replies

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jun 17, 2014 at 11:52 AM
Hi Jutulu,

You mean something like this?:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MyWidth As Currency

MyWidth = Target.ColumnWidth

Target.EntireColumn.AutoFit

If Target.ColumnWidth >= MyWidth Then
    Target.ColumnWidth = MyWidth
    Exit Sub
End If

Do
    Target = Target & "."
    Target.EntireColumn.AutoFit
Loop Until Target.ColumnWidth = MyWidth

End Sub


Best regards,
Trowa
5
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Jun 18, 2014 at 06:10 PM
Hi Trowa,

I didn't want to use macros. However, there is a much easier way to do it. I sow it once and thought it was very cool, but never wrote it down and can't remember it. Thanks anyway. Hope can find the answer to it.
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jun 19, 2014 at 10:35 AM
OK Jutulu, I got it.

Go to cell properties > number tab > go to the manual input and type in "@*."

Enjoy.

Best regards,
Trowa
0
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Jun 19, 2014 at 07:27 PM
Great! It was just that. Thank a lot. Only, you mean to go to custom option at the bottom, not number
0