0

Using VBA in excel for a Cell Border (not a chart):

Cannot set the Borders.Linestyle property to have the round dot linestyle (see attached photo). Using .Linestyle = xlDot results in the larger, square dashes rather than the smaller round dots.

I've also tried setting weight to xlThin but this does not seem to make a difference.

enter image description here

ericauv
  • 160
  • 16

1 Answers1

3

Try

.LineStyle = xlContinuous
.Weight = xlHairline
FunThomas
  • 23,043
  • 3
  • 18
  • 34
  • 1
    Welcome. Btw: I quickly fired the Macro-Recorder to find out. That's usually the best way to find these little things in Excel – FunThomas May 15 '18 at 14:36
  • I was doing that when first learning VBA but had totally forgot about that method of learning! Thanks again! – ericauv May 15 '18 at 14:41