Lance
  • Lance
  • Newbie Topic Starter
2020-11-13T01:01:03Z
Hi everyone,

Hoping someone is able to help with this one, I have iGrid directly on a FactoryTalk View SE display. I have changed the object properties so that it has VBA control and can access the control properties in VBA.

all I am doing in the image is adding a column, works fine on a userform but when I run it directly on the display i get
Capture2.PNG

Click to View Image45 View(s)



the code I am running is

Capture2.PNG

Click to View Image48 View(s)



and thats the line it falls over on. It can access the control and obviously knows what .BeginUpdate is but has an issues on .AddCol.

Rockwell tech support is no help as they don't support VBA issues so any help or suggestions would be much appreciated.

Cheers
Lance
Igor/10Tec
2020-11-13T13:02:12Z
The only idea that came into my mind by this moment is to change the name of your control from 'iGrid' to something else like 'iGrid1'. iGrid can be processed as the class name of the control, and perhaps, this causes the problem.
Lance
  • Lance
  • Newbie Topic Starter
2020-11-15T19:16:13Z
Thanks Igor,

I have tried to name it many things in my attempts to make it work but haven't been able to as yet. I will update this thread if I find a solution.

Cheers
Lance