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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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