hpw to float the uderform across worksheet ?

Hello,

I'm trying to make userform to be floating over worksheet in active workbook.
Anybody can help ?
scsong71Asked:
Who is Participating?
 
avidyaConnect With a Mentor Commented:
hi,

rightclick on the tab in excel choose "view programcode" (don't know exactle, have Dutch myself)

add this:

Private Sub Workbook_Open()
 Worksheets(1).ShowDataForm
End Sub
0
 
avidyaCommented:
you can make an macro called "autostart" which displays your form on opening the sheet
0
 
scsong71Author Commented:
Thanks for the advise, but how I can make my macro autostart ?
0
 
avidyaCommented:
hi scsong71,

Plaese let me know why you graded my answer a "c"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.