Object Required Error With A Userform

[Ark68]

I seem to be stuck with a problem that likely has a very simple solution ...

My Code ...

        'update userform
        With uf1_main
        'active
            With .lb_cntaba_dt
                .Caption = cnt_dt
                If cnt_dt = 0 Then
                    .Enabled = False
                    .lb_aba_dt.Enabled = False
                End If
            End With
            ...

uf1_main is a userform and and I'm trying to update it's objects. I am getting an "object required" error with the line in red which I assume means the actual userform isn't being recognized.

 

[Trebor76]

The reason I asked to see all the code was to ensure you haven't started an If or With statement without an equivalent End If or End With.

There's nothing else I can suggest I'm afraid

Someone else on the forum may have an idea as to how to solve the issue.

Robert

 

[Ark68]

Thanks Robert for trying!

 

[Trebor76]

You're welcome

Just looking at your original post - it is missing an End With i.e. it should look like this:

update userform
With uf1_main
    'active
    With .lb_cntaba_dt
        .Caption = cnt_dt
        If cnt_dt = 0 Then
            .Enabled = False
            .lb_aba_dt.Enabled = False
        End If
   End With
End With

 

[Ark68]

Hi Robert, that would be awesome if that was the problem!! My OP didn't go into the full code, but in addition to the label presented, I had about a dozen more also being updated "With uf1_main". (See the purple bits in my full code, they were all within the With - End With". I'm confident I hadn't excluded that, but I'm not certain. It might be worth revisiting.

 

[Ark68]

No. That sadly wasn't it.

 

[RoryA]

You can't use the Designer on an open form. You also can't use the default instance of a form that is in another workbook. You'd need a function in the other workbook that returns the form before you can manipulate it from a different workbook. The whole thing sounds like bad design to me though.

 

[Ark68]

Thanks Rory. I am going back to the design board.

 

[Ark68]

Not sure if I should start another thread or not, but I'm considering closing the form 'group_1' once the information has been submitted. Doing this exposes the open userform 'uf1_main', but it's in a static condition.
After I close group 1, how can I force 'uf1_main' to update it's statistical information based on the changes made by the user input from 'group_1'? I could put an "update button" on the form, but I'd prefer it be a bit more automated? Could a run a macro (in wb1) from wb2, (the one that closed 'group_1"), that would provide the updates?

 

[RoryA]

You can use Run to run code in a different workbook, but it still sounds to me like you need to redesign the whole thing, as it's all too interdependent as it stands.