Label, Text and Form controls in Excel 97

[TomCee]

Hello:

I am programming userforms, text and label controls in Excel97.

How does one make these appear in the spreadsheet environment?

Thanks in advance,
TomCee

 

[Bernie Deitrick]

TomCee,

You need to use a macro: if your userform is Userform1 (the default), then
you would simply use:

Sub ShowUserform1()
Load UserForm1
UserForm1.Show
End Sub

HTH,
Bernie
MS Excel MVP