ActiveX controls disappearing while running a macro

I have a poblem with ActiveX controls in the spreadsheet (bcommand buttons, combos, text boxes, spin buttons).

Basically when macros are running performing different things (calculations or outputting something on screen), all ActiveX controls, disappear for a while. The rest of the excel screen is stable (of course during all types of calculations screenupdating and enableevents options are off.

Everything works fine - only there is this unwanted effect of blinking ActivaX controls.

Have you ever encountered something like that? Is there a way to avoid it?

Thanks anse best

Yes, I know and I am going to change my code in this direction.
Still - user forms will be activated by buttons, and buttons will blink

Thanks for a thought!

I will try to search how it works (never used it before)

Thanks a lot!

Joseph - in fact I would like to ask you a favour. I wanted to post a new thread - but apparently I cannot do that (HTTP error 403 - forbidden access bla bla bla...)

I think you are the moderator - could you establish the new thread for me? And maybe you can help? Thanks in advance and best regards

ListView problem for 64-bit OS

All,

one more question to the more experienced VBA programmers...

In my application I used Microsoft Liustview 6.0 control, which looks and works excellent, it has exactly properties like I need, and now I cannot even think of using something like ListBox instead.

There is one problem: it turned out that it is not compatible with 64-bit operating system (used by quite a few people in my company). It is really frustrating.

Is there any way to deal with that? Perhaps there might be alternative controls that have similar properties and can be used both on 32 bit and 64 bit systems?

I use this control for the multiple selection panel. The properties that I am very happy with are:
- named columns (as each displayed position has couple of fields)
- adjustable column width (as some of the fields like folder names tend to be longer than default width)
- checkboxes (if there are a lot of positions they are more convenient than multiple selection, but perhaps I could live without them...)

I will appreciate all your hints. Regards

Thanks, this is very helpful. Two additional questions:
1. Do they intend to solve it?
2. Is it not a problem to install 32 bit Office on the 64 bit OS?

Thanks and best regards

Guys,

It has been a while - I am getting down to development of the ribbon (from the link you provided to me: www.rondebruin.nl/ribbon.htm)

General question: if I create jus a simple menu tab for my software - may I expect problems with different version of Excel? And which issues can raise to problems - and which not?

I am using Excel 2010.

Thanks and best regards