Refresh OLE Objects

[tonykslee]

Hey guys,

I have 2 subs. One sub that deletes all OLE SpinButtons, and one that Creates them.
If i run these two subs separately then it works just fine, but when i call both of them within a third sub, it freaks out and creates the buttons all out of order and linked to the wrong cells.

Here is the skeleton of my code:

'deletes and creates all spinners
Sub refreshSpinners()
    Application.ScreenUpdating = False
    deleteAllSpinners
    createAllSpinners
    Application.ScreenUpdating = True
End Sub


'clear all spin code - test code
Sub deleteAllSpinners()
    For counter1 = 1 To Worksheets("Profiles").Cells(totalProjectsY, totalProjectsX)
        deleteSpinCode (counter3)
        deleteSpinButton (counter1)
    Next
End Sub


'create all spin buttons test code
Sub createAllSpinners()
    For counter1 = 5 To Worksheets("Profiles").Cells(totalProjectsY, totalProjectsX) + 4
        addSpinCode (counter2 - 4)
        createSpinButtons (counter2)
    Next
End Sub

Also posted question in:
ExcelForum: http://www.excelforum.com/excel-programming-vba-macros/1006817-refresh-ole-objects.html
OzGrid: http://www.ozgrid.com/forum/showthread.php?t=187898&p=711299#post711299

 

[shg]

Try putting Option Explicit as the first line of the code module.

 

[tonykslee]

Thanks for the reply, shg

but I already have it in there. =\

 

[shg]

Where is counter1 declared?

Where are counter2 and counter3 declared and initialized?

 

[tonykslee]

Where is counter1 declared?

Where are counter2 and counter3 declared and initialized?

Sorry about that,

counter 1, 2 and 3 are fields that are declared as integers at the top. I use the same counter names throughout my code

 

[shg]

Lacking the big picture, what happens when you step through the code?

 

[tonykslee]

So basically, there's a button that adds a 'project'.
This project has a field that i have a spinner button attached to it.

When i add/delete a project, i don't want a spinner button to be there if there is no project. and i don't want a project to be there without a spinner.
i hope that clears it up a bit..

 

[tonykslee]

I re-coded it to just toggle visibility!
This works great!

Though the issues with the out of order spinners wasn't solved, i'm gonna mark this as solved just because an alternate solution was found!

Thanks a lot!