Label, Text and Form controls in Excel 97

T

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
 
B

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
 
Top