multi activex drop list_ problem_ sometimes can not select an item of the list

%3CLINGO-SUB%20id%3D%22lingo-sub-1496096%22%20slang%3D%22en-US%22%3Emulti%20activex%20drop%20list_%20problem_%20sometimes%20can%20not%20select%20an%20item%20of%20the%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496096%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20have%20a%203MB%20excel%20file%20with%205%20ActiveX%20combo%20boxes%20(1%20text%20box%2C%205%20drop%20lists).%3C%2FP%3E%3CP%3EThe%205%20drop%20lists%20are%20associated%20to%20names%20(name%20manager)%20and%20are%20dependente%20between%20them.%3C%2FP%3E%3CP%3ESometimes%20I%20can%20not%20select%20a%20item%20on%20the%20lists%E2%80%A6%20the%20cursor%20is%20the%20cross%20when%20above%20the%20lists.%20So%20I%20can%20not%20select%20the%20items%20the%20lists%20presents%20(It%20hapens%20with%20the%20design%20mode%20off)%3C%2FP%3E%3CP%3EI%20can%20solve%20that%20by%20turning%20on%20and%20then%20turning%20off%20the%20design%20mode.%20The%20problema%20is%20fact%20the%20file%20is%20used%20by%20others%20and%20so%20its%20annoying%20telling%20them%20to%20turn%20off%20and%20on%20the%20design%20mode.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1496096%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hi!

I have a 3MB excel file with 5 ActiveX combo boxes (1 text box, 5 drop lists).

The 5 drop lists are associated to names (name manager) and are dependente between them.

Sometimes I can not select a item on the lists… the cursor is the cross when above the lists. So I can not select the items the lists presents (It hapens with the design mode off)

I can solve that by turning on and then turning off the design mode. The problema is fact the file is used by others and so its annoying telling them to turn off and on the design mode.

0 Replies