I also want to add this to the list of my problems:
If I currently open multiform.xlsm from within excel (default file is Book1.xlsx), then only the Book1.xlsx file is visible, the multiform spreadsheet is not visible - neither code window nor spreadsheets are showing. When I exit the Book1.xlsx a dialog is coming up asking me, whether or not I want to save changes to multiform.xlsm. In the task manager, multform.xlsm are not visible at that point of time.
Today I loaded a second macro enabled workbook which implements a graph according to worksheet data. I was not even able to enter the formula =now() into a cell. Currently there are 18 dialogs integrated in a multipage control. The code is complex for a few forms only and in this case barely exceeds 200 lines. For example: A form showing images, which rely on data written to a worksheet from a SQL statement, having an impact on graphs in that worksheet. The graphs are then exported as jepegs and imported into an image control.
The form in this example shows without flaw, the dialogs don't flicker, the combo boxes and list boxes events seem to execute as to expectation, so I don't think: Endless loop,
The following are my problems
- As I open the workbook, without even touching the Developer Menu, there is a busy cursor showing
- I cannot open the main form (containing the multipage control) in design mode after having executed the macro; I only can access the form in design mode, after
restarting the workbook
- When opening a second workbook, I cannot input a formula
Please, if anybody has an idea about this or find my reasoning faulty, please don't hold back.
Thank you for your help.
This is what I see in my task manager. When the mouse cursor hovers over the project explorer, it shows busy.
In the attached image you can see my workspace, when opening the multiform at the location, where most of my "ghost controls" are located. Here is my form and as you can see, not all the controls are listed. The controls surrounded by frames are not identified.
[1]: /answers/storage/attachments/151177-frmreportingcontrols.png
What I did then is: I extended my frames and found all the ghost controls - a sort of replicating my whole form with
default naming convention - and deleted them. Thanks to you I started looking, again.
Yes, you are right.
The problem is that in the same function I used different syntax
for the identical variable. I don't seem to be able to treat one and
the same item as object and as array in the same code segment
(function or sub)
So what I did was to identify the object using the typename function
create appropriate functions and and pass the object to the function
This worked for me.
Thank you.
Thank you. I followed up on the link you provided, but it was my Antivirus program which was the culprit. Merry Christmas.