Active X Control - rclick menu

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,835
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hi, I've some active X controls which have taken on odd behaviour.
They are label and combo box controls. As I mouse over them the cursor becomes a 4 pointed thing
whether I go to design mode, or not. There's no dropdown action. A right click shows a different menu to the expected one
starting Cut, Copy, Paste Options (like a r-click anywhere but with a Shapes dialog).

If I made a new ActiveX control it behaves itself and has the correct r-click menu.

Ant idea why/what is happening? And can I fix these or do I need to delete and make new ones?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
I have experienced this problem many times before specially after enduring an excel crash (when testing some code)
The only fix I know of is to delete the control(s) and create a new one.

Can you not use Form controls instead of activex ?
 
Upvote 0
Actually in trying to sort this I only became aware that Form Controls existed, but couldn't figure how to set properties like size, left, top, font etc.
So I think I *need* Active X controls. They in a sort of Line 1 banner (where width/backcolor differs from the rest of the sheet).
Thanks for replying... I'll set about remaking them all. Hopefully they'll stay that way this time !
 
Upvote 0

Forum statistics

Threads
1,214,806
Messages
6,121,672
Members
449,045
Latest member
Marcus05

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top