Using this code

With Me
'make sure there's a data source, destination, and title
If Trim(.cmbDstSheet.Value) = "" Or _
Trim(.refSrcRange.Value ) = "" Or _
Trim(.txtChartTitle.Value) = "" Then


I am getting a compiler error at the word Trim that can't find project or
library

the cmbDstSheet.Value is corectly named in the form design as is the
refSrcRange.Value. If I rem out cmb I still get the same error at trim with
ref

Any ideas ?

Thanks

Click Tools/References on the VBA editor's menu bar and see if any
references are missing. If so, check the box next to them and see if that
straightens things out.

Rick


"lwm" <(E-Mail Removed)> wrote in message
news12ED920-EBF8-40BD-A4F0-(E-Mail Removed)...
> Using this code
>
> With Me
> 'make sure there's a data source, destination, and title
> If Trim(.cmbDstSheet.Value) = "" Or _
> Trim(.refSrcRange.Value ) = "" Or _
> Trim(.txtChartTitle.Value) = "" Then
>
>
> I am getting a compiler error at the word Trim that can't find project or
> library
>
> the cmbDstSheet.Value is corectly named in the form design as is the
> refSrcRange.Value. If I rem out cmb I still get the same error at trim
> with
> ref
>
> Any ideas ?
>
> Thanks
>

Rick

I seem to have an error in my RefEdit.dll

Thanks


"Rick Rothstein (MVP - VB)" wrote:

> Click Tools/References on the VBA editor's menu bar and see if any
> references are missing. If so, check the box next to them and see if that
> straightens things out.
>
> Rick
>
>
> "lwm" <(E-Mail Removed)> wrote in message
> news12ED920-EBF8-40BD-A4F0-(E-Mail Removed)...
> > Using this code
> >
> > With Me
> > 'make sure there's a data source, destination, and title
> > If Trim(.cmbDstSheet.Value) = "" Or _
> > Trim(.refSrcRange.Value ) = "" Or _
> > Trim(.txtChartTitle.Value) = "" Then
> >
> >
> > I am getting a compiler error at the word Trim that can't find project or
> > library
> >
> > the cmbDstSheet.Value is corectly named in the form design as is the
> > refSrcRange.Value. If I rem out cmb I still get the same error at trim
> > with
> > ref
> >
> > Any ideas ?
> >
> > Thanks
> >
>
>

I presume you are seeing this error in the References, right? Is the box
next to this dll checked? If not, put a check in it and see if that fixes
it.

Rick


"lwm" <(E-Mail Removed)> wrote in message
news:B3EA5AB8-532F-432E-96BA-(E-Mail Removed)...
> Rick
>
> I seem to have an error in my RefEdit.dll
>
> Thanks
>
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> Click Tools/References on the VBA editor's menu bar and see if any
>> references are missing. If so, check the box next to them and see if that
>> straightens things out.
>>
>> Rick
>>
>>
>> "lwm" <(E-Mail Removed)> wrote in message
>> news12ED920-EBF8-40BD-A4F0-(E-Mail Removed)...
>> > Using this code
>> >
>> > With Me
>> > 'make sure there's a data source, destination, and title
>> > If Trim(.cmbDstSheet.Value) = "" Or _
>> > Trim(.refSrcRange.Value ) = "" Or _
>> > Trim(.txtChartTitle.Value) = "" Then
>> >
>> >
>> > I am getting a compiler error at the word Trim that can't find project
>> > or
>> > library
>> >
>> > the cmbDstSheet.Value is corectly named in the form design as is the
>> > refSrcRange.Value. If I rem out cmb I still get the same error at trim
>> > with
>> > ref
>> >
>> > Any ideas ?
>> >
>> > Thanks
>> >
>>
>>