Overall VBA Error

[jonas-martens]

All,

When I try to run a macro, I keep on getting this error:
Error.png

The strange thing is, I am the only one having this problem.
None of my colleagues are...

Is it a plug-in I am missing or ... ?

thx in advance.

[Andy Pope]

In VBE use Tools > References, and check list for Missing references.

[xlnitwit]

Hi,

What type of control is fg?

[jonas-martens]

Hi Andy,

Thanx for your reply.
A colleague of my can enter the file, and our references are the same.

[jonas-martens]

Hi,

I totally have no idea ;/

I'm not the person who has made this file.
The .fg returns a lot in the code, but I have no clue where it is standing for...

SOme examples :
UserAnalyse.fg.TextMatrix(0, 0) = ""
UserAnalyse.fg.TextMatrix(T, 1) = x.Offset(0, 1)
UserAnalyse.fg.TextMatrix

Anyone has an idea why the .fg. is in place?
thx

[xlnitwit]

My best guess would be that fg is a FlexGrid control that you do not have. The reason Andy was asking about references- which are workbook specific- is that if you open the file you will probably see one of the selected references shown with 'MISSING:' at the start of its name. Do you have the same version of Office as everyone else? (If you have 64bit Office, the FlexGrid control will not be available to you).

[jonas-martens]

That's the missing link!

Thanks man!

[xlnitwit]

You're welcome.

Please don't forget to mark the thread Solved using the Thread Tools dropdown at the top of the page.