Data form errror

L

lwm

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
R

Rick Rothstein \(MVP - VB\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top