ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   adding Activex control through code works BUT... Cannot access ob (https://www.excelbanter.com/excel-programming/304076-re-adding-activex-control-through-code-works-but-cannot-access-ob.html)

keepITcool

adding Activex control through code works BUT... Cannot access ob
 
looks like some sort of focus or selectino problem:

try:
..visible=false
..visible=true

sometimes it works :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?Sm9uTW55?= wrote:

I have an activex control that I have created (basically a textbox
that automatically rezizes) When I add it to an excel sheet using VBA
it adds but I cannot select it or type in it unless I switch to
design mode then out of design mode any Ideas?




All times are GMT +1. The time now is 03:05 AM.

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