IF statement for future worksheet???

[Big Lar]

During UserForm Initialize…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
How to ignore
<o></o>

Label107.Caption = Sheet8.Range("A3").Value

<o></o>
If Sheet8 does not yet exist?
<o></o>
I’ve tried several If statements without success.
<o></o>
Sheet8 is created via Module1 code…and will always be named “<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on">PO</st1lace> (2)”

Thanks for looking.

 

[shg]

Assuming the worksheet has been created when the code runs,

    Label107.Caption = Worksheets("PO(2)").Range("A3").Value

 

[Big Lar]

Ah...there's the rub.

UserForm1 CommandButton1 runs Module1.
Module1 Hides UserForm1
Module1 does stuff including creating sheet "PO (2)" and...
UserForm1.Show.

Private Sub UserForm_Initialize()
would then display:

Label107.Caption = Sheet8.Range("A3").Value

 

[shg]

I'm not sure what rub you're referring to, but you can't use the codename of a sheet that doesn't exist; the code won't compile.

You can use the name of a non-existent sheet, as long as the sheet is created before it runs.

 

[mvptomlinson]

To check if a sheet exists before referencing it, you could use something like:

Dim ws As Worksheet

On Error Resume Next
Set ws = Sheets("PO (2)")
If Len(ws.Name) = 0 Then  'Sheet does not exist
    On Error GoTo 0
    MsgBox "Sheet ""PO (2)"" does not exist"
    Exit Sub
End If ' or do something else, run more code, etc.

 

[Big Lar]

The rub?

Assuming the worksheet has been created when the code runs...

The worksheet is created by the code. I'm trying to display results on the UserForm after "PO (2)" is created and data sorted.

I was hoping an IF statement in UserForm1_Initialize would do the trick. I'll have to rethink the process.

Thanks for the assistance.

 

[shg]

As long as the worksheet has been created when that line (my line) of code executes, you're fine.