Excel will not close

[AlexanderBB]

I've truck an oddball problem. My workbook opens ok, and to test I load my Form from the immediate window and close it
If I then attempt close Excel. I get the wait cursor forever and need to Contrl-Alt-Del End task.

Could someone in the know take a look at it please ? I have proved the issue into a demo, but want to discuss macros first
as some may need remming out.

But I'm told I may not post attachments. Can I change that ?

Thanks for any help with this.

 

[AlexanderBB]

I've isolated the problem, I think but it isn't clear why it's happening.

Private Sub UserForm_Initialize()

MsgBox "Initialise"
Dim i As Long
    For i = 1 To 48
        Me.Frame1.Controls("CommandButton" & Format(i, "00")).Caption = vbNullString
        Me.Frame1.Controls("CommandButton" & Format(i, "00")).Tag = Me.Frame1.Controls("CommandButton" & Format(i, "00")).BackColor
        Set MyClass(i) = New clsPressBtn
        Set MyClass(i).GetForm = Me
        Set MyClass(i).Btn = Me.Frame1.Controls("CommandButton" & Format(i, "00"))
    Next


End Sub

The Form loads/runs correctly. But if the above isn't remmed out (apart from the MsgBox), Excel will not close.
Yet the msgbox does not appear when attempting to close, indicating that code isn't running.

Can anyone help me debug this ?

 

[AlexanderBB]

Excel Problem closing

I have a macro-enabled workbook in Dropbox

https://www.dropbox.com/s/burhl3jawqhj05a/PickerOnly.xlsm?dl=0

Could someone please have a look at this. When it opens a Form loads with a color picker.
The color clicked becomes backcolor to a couple of labels on the Form when clicked.

The problem is (whether the picker is used or not), closing that Form will crash Excel. It will never close after that.
If the Form is not closed first though, Excel will close normally.

I can't figure out why though, or how to correct it. Any help appreciated.

 

[Fluff]

Re: Excel Problem closing

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1267181-code-picker.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Joe4]

Re: Excel Problem closing

But I'm told I may not post attachments. Can I change that ?

No one can post attachments.
See: https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[AlexanderBB]

Re: Excel Problem closing

Thanks Joe, that clears that up. Fluff, I "crossposted" as you call it as no one had replied here and I *could* include an attachment on the other site. The we no point referencing it there's nothing there except the original question.
Isn't it sad how people can take time out to complain about something ignoring that someone may be trying to get help with a problem.

 

[Norie]

Re: Excel Problem closing

AlexanderBB

Did you check my response on the other forum?

 

[Joe4]

Re: Excel Problem closing

Please read this to understand the issue with Cross-Posting: https://www.excelguru.ca/content.php?184

As our rules state, it is not a problem if you do it correctly (provide links). Sure there may not be a reply on the other site at a particular point in time, but that can change pretty fast, especially when you are away from the computer for a while.

Two things to remember:
- People volunteer their time responding to questions. No one like to feel like they have wasted their time because the same answer may have already been posted elsewhere, or if the problem has already been answered elsewhere.
- As you can see, there is a lot of cross-over, in that many people post on multiple forums. For the sake of getting replies to your question, you really don't want to develop a reputation, because it does get around to the other sites pretty fast.

 

[AlexanderBB]

Re: Excel Problem closing

Ok Joe, understood. Just reading Nories reply now.