ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OleObjects very urgent issue (https://www.excelbanter.com/excel-programming/443282-oleobjects-very-urgent-issue.html)

avi

OleObjects very urgent issue
 
Hello,

I have inserted an ActiveX in the Activesheet and so far I was able to
reference its Object property.

For example MsgBox TypeName(g.object) will return "CircleGauge1" , the
name and index of the the control . g is defined as OleObject

Strangely and suddenly, the same command returns "RunTime1004, unable
to get the object property of the OleObjects class" although the
ActiveX in properly registred

What is more strange is that from time to time it starts to work again
but I could not figure out the logic

I am really stucked and your help will be very appreciated
Avi


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com