Label, Text and Form controls in Excel 97
 

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

Label, Text and Form controls in Excel 97
 

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

"TomCee" wrote in message
om...
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