View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel developers mindset

There is an alternate method, FontStyle:

Worksheets("Sheet1").Range("A1").Font.FontStyle = "Bold Italic"--
Regards,Tom Ogilvy"GB"
wrote in message ...
I am still trying to understand the thinking behind certain things in VBA.

Can anyone explain why to make a cell bold and italic the following is

done:

Range("A1").Font.Bold = True
Range("A1").Font.Italic = True

Rather than:

Range("A1").Font = xlBold + xlItalic

I can see that Bold is just one of the properties of the font and you

either
switch it on or off. So the way it is implemented is absolutely logical.

But
why is the other way of doing it illogical then?

Geoff