making userform objects not visible on startup

[spalton]

Hi there,

My first day trying to work out visual Basic!

I've got a number of objects laid out on my userform, but some of them need to be invisible before a button in pressed.

I need it to hide the labels, other buttons etc on startup everytime the workbook is opened.

I've tried the following code just in the workbook-open function but it isn't working? is it because I need to reference the userform in someway?

Private Sub Workbook_Open()
ActiveWorkbook.Sheets("working").Activate
Range("c3:c5").Value = "NA"
Range("c8:c12").Value = "NA"
Range("c15:c19").Value = "NA"
Range("c25:c27").Value = "NA"
the above all work fine
label16.visible = false does not work
End Sub

How do I reference the userform?

Thanks!

 

[Kaps_mr2]

You need to put the label16 on a form. Within VB to go Insert and select form. Drag your label onto the form (which will be Userform1 by default).

This will be hidden and you can display Userform1 with :-

Userform1.Show

to hide it :-

Userform1.Hide.

Thks

Kaps

 

[spalton]

Yep, got that working, with the label16 on the form, problem is only certain things on the form need to be hidden, others need to remain visible.

Can i isolate specific objects in the form to be hidden at startup?

 

[Kaps_mr2]

I don't think you can. My only suggestion would to have several forms (userform1, Userform2 etc) and show them when necessary. Thks

Kaps