Re: Color Index

Now you don't have to presume.

--
Regards,
Tom Ogilvy

"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eBkMzQOpFHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
> That is the '... presumably it can be changed ... ' that I mentioned.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
> news:exHQEDOpFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
> > If you change your setting for the window font color in the windows (not
> > excel) settings, it changes the color in the cells that are set for
> > xlautomatic - so it isn't necessarily the black(ish) font color.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:%23vD57uNpFHA.3304@xxxxxxxxxxxxxxxxxxxxxxx
> > > It is the black(ish) font colour, but presumably as it is called
> automatic
> > > it can be changed, or MS have reserved the option to make it
> configurable.
> > >
> > > --
> > >
> > > HTH
> > >
> > > RP
> > > (remove nothere from the email address if mailing direct)
> > >
> > >
> > > "Bill" <bill@xxxxxxxxxxxxxxxxx> wrote in message
> > > news:FdnNe.10076$Je.9839@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > > Thanks, but I want to know the color that is represented by the
> > > > xlColorIndexAutomatic. How do I do that?
> > > >
> > > >
> > > > "Vasant Nanavati" <vasantn AT aol DOT com> wrote in message
> > > > news:%23GQ5zRNpFHA.2504@xxxxxxxxxxxxxxxxxxxxxxx
> > > > > -4105 is the constant represented by xlColorIndexAutomatic. If you
> > want
> > > > > the color to be blue try to set it specifically.
> > > > >
> > > > > --
> > > > >
> > > > > Vasant
> > > > >
> > > > >
> > > > > "Bill" <bill@xxxxxxxxxxxxxxxxx> wrote in message
> > > > > news:jOmNe.10056$Je.1311@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > > >> Hello,
> > > > >> I have a bar chart is made and then updated. For some reason,
when
> > > > >> updating, the color changes from blue to purple. When I ask what
> the
> > > > >> color index is for the bar, prior to updating, I get -4105. Not
> the
> > > > >> color index I would expect for blue. I used:
> > > > >>
> > > > >> Activechart.seriescollection(1).interior.colorindex
> > > > >>
> > > > >> Any ideas on what is happening? Is the -4105 some default
setting?
> > > > >>
> > > > >> Thanks,
> > > > >>
> > > > >> Bill
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: type mismatch?
    ... >> public sub myFunc(a as variant, b as variant, optional c as variant, ... >> HTH ... >>> Regards, ... >>> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: What does this do?
    ... HTH... ... "Tom Ogilvy" wrote: ... >> Jim Thomlinson ... >>> Regards, ...
    (microsoft.public.excel.programming)
  • Re: Testing a string array for any values
    ... > Tom Ogilvy ... >> HTH ...
    (microsoft.public.excel.programming)
  • Re: Need VBA code for Save As dialog
    ... Application.Dialogs.Show fname ... HTH ... "Tom Ogilvy" wrote: ...
    (microsoft.public.excel.programming)
  • Re: starting another program
    ... If you aren't using Windows 9x or Millenium, ... Regards, ... > Dim intFile As Integer ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)