RE: Combined VBA line syntax

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Charlie -
Clearer than mud, sure. the 'method' terminology clears it up. I've
just got to learn more about that. I left the blank on purpose trying to
emulate the protection method without realizing the import of what I did.
Live and Learn.
thanks,
Neal


"Charlie" wrote:

> Let me be a little more explicit on the language syntax the compiler is
> expecting. Properties are used to set or get values:
>
> Object.Property = Value
> Value = Object.Property
>
> Methods are functions that are passed values as arguments
>
> Object.Method Arg1, Arg2, Arg3, etc.
> e.g.
> Worksheet.Protect "ABC123", True, True
>
> The arguments must be entered in the order the method is expecting them, and
> missing (optional) arguments must have commas as placeholders (except for
> missing arguments at the end.)
>
> Object.Method Arg1, , Arg3, , Arg5
>
> If you only want to supply specific arguments then you use the argument name
> in the following syntax (and the order is not critical)
>
> Worksheet.Protect Password:=”ABC123”, AllowFormattingCells:=True
>
> In your example you removed the dot between
>
> Cells(x, y).Borders(xlEdgeLeft)
>
> and
>
> LineStyle
>
> Effectively telling the compiler you wanted to call an unnamed method using
> two arguments, LineStyle and Weight
>
> Cells(x, y).Borders(xlEdgeLeft) LineStyle:=xlContinuous, Weight:=xlThick
> (no method name).....................^
>
> Clear as mud?
>
> "Charlie" wrote:
>
> > I think it's because .Linestyle and .Weight are properties that are set to
> > values, while .Protect is a method, which is like a subroutine that accepts
> > arguments. Someone more advanced please correct me if I'm mistaken!
> >
> > "Neal Zimm" wrote:
> >
> > > Being mostly self taught in VBA I tried to combine lines a and b into c,
> > > using line d as an example from recording a macro.
> > >
> > > compiler did not like line c.
> > >
> > > How do you know when "combining" lines will work and when it will not?
> > > thanks.
> > >
> > > Cells(x, y).Borders(xlEdgeLeft).LineStyle = xlContinuous '' a
> > > Cells(x, y).Borders(xlEdgeLeft).Weight = xlThick '' b
> > >
> > > Cells(x, y).Borders(xlEdgeLeft) LineStyle:=xlContinuous, Weight:=xlThick '' c
> > >
> > > ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
> > > '' d
> > >
> > >
> > > --
> > > Neal Z
.

Relevant Pages

  • Re: GCC compiler error
    ... Do *you* Charlie? ... Charlie Gordon was knocking the compiler, ... that Jacob had a duty to release his work for free. ...
    (comp.lang.c)
  • Re: Mongrel HTTP Library 0.2.0 (Fast And RubyForgified)
    ... C conditionally dependent on whether or not a compiler is available. ... Charlie ... Prev by Date: ...
    (comp.lang.ruby)
  • Re: GCC compiler error
    ... that Jacob had a duty to release his work for free. ... Charlie made a joke, which happened to have a serious ... Of course, Navia has no sense of humor, and went off on ... I was not knocking the compiler at all. ...
    (comp.lang.c)
  • Re: Important note
    ... Costing the net hundreds if not thousands of dollars, Charlie Don't Surf ... that a `compiler' was a person. ...
    (uk.misc)