Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Error 459 on callup of UserForm with ActiveX control

Hello All,

We have an Add-In that uses a VB6 ActiveX control on a UserForm. The
UserForm is simply called up from a toolbar macro saying "MyForm.Show".

The ActiveX control sits on a Multipage control, inside another Multipage
control.

Recently, we have started to get an error on deployed versions of our
Add-In: "Run-time Error 459: Can't move focus to the control because it is
invisible, not enabled, or of a type that does not accept the focus."

This control and mechanism has worked fine in the past.

The part that puzzles/frustrates me the most, I guess, is that if I get on
the machine, and manually remove and re-add the control on the form in the
Add-In, it works fine.

AAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGHHHHH HHHHHH!!!!

Any help would likely lengthen my sanity for a few more minutes, and I guess
that would be appreciated.

Thanks,
PAGates
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Error 459 on callup of UserForm with ActiveX control

Might be worth checking that the respective versions of the ActiveX are
same.

Regards,
Peter T

"pagates" wrote in message
...
Hello All,

We have an Add-In that uses a VB6 ActiveX control on a UserForm. The
UserForm is simply called up from a toolbar macro saying "MyForm.Show".

The ActiveX control sits on a Multipage control, inside another Multipage
control.

Recently, we have started to get an error on deployed versions of our
Add-In: "Run-time Error 459: Can't move focus to the control because it is
invisible, not enabled, or of a type that does not accept the focus."

This control and mechanism has worked fine in the past.

The part that puzzles/frustrates me the most, I guess, is that if I get on
the machine, and manually remove and re-add the control on the form in the
Add-In, it works fine.

AAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGHHHHH HHHHHH!!!!

Any help would likely lengthen my sanity for a few more minutes, and I

guess
that would be appreciated.

Thanks,
PAGates



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Error 459 on callup of UserForm with ActiveX control

Hi Peter,

Yes, they are the same. I guess I didn't explain clearly enough.

I simply open the VBA project on the client machine, open the form, delete
the existing control, add it to the toolbox, and add it to the form. I don't
download a new version of the control.

Thanks,
PAGates

"Peter T" wrote:

Might be worth checking that the respective versions of the ActiveX are
same.

Regards,
Peter T

"pagates" wrote in message
...
Hello All,

We have an Add-In that uses a VB6 ActiveX control on a UserForm. The
UserForm is simply called up from a toolbar macro saying "MyForm.Show".

The ActiveX control sits on a Multipage control, inside another Multipage
control.

Recently, we have started to get an error on deployed versions of our
Add-In: "Run-time Error 459: Can't move focus to the control because it is
invisible, not enabled, or of a type that does not accept the focus."

This control and mechanism has worked fine in the past.

The part that puzzles/frustrates me the most, I guess, is that if I get on
the machine, and manually remove and re-add the control on the form in the
Add-In, it works fine.

AAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGHHHHH HHHHHH!!!!

Any help would likely lengthen my sanity for a few more minutes, and I

guess
that would be appreciated.

Thanks,
PAGates




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
ActiveX control error - Red Excel Programming 0 October 15th 05 12:30 AM
Userform Control Error Wild Horses Excel Programming 1 October 3rd 05 04:46 PM
Error 50290: Error writing to Worksheet while using an ActiveX Control emblair3 Excel Programming 3 February 24th 04 06:03 PM
ActiveX Error w/Calendar Control Ron Armstrong Excel Programming 0 October 24th 03 01:25 AM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"