Solved

hpw to float the uderform across worksheet ?

Posted on 2004-08-08
4
266 Views
Last Modified: 2010-04-17
Hello,

I'm trying to make userform to be floating over worksheet in active workbook.
Anybody can help ?
0
Comment
Question by:scsong71
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 10

Expert Comment

by:avidya
ID: 11748813
you can make an macro called "autostart" which displays your form on opening the sheet
0
 

Author Comment

by:scsong71
ID: 11758761
Thanks for the advise, but how I can make my macro autostart ?
0
 
LVL 10

Accepted Solution

by:
avidya earned 500 total points
ID: 11758932
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
 
LVL 10

Expert Comment

by:avidya
ID: 11781018
hi scsong71,

Plaese let me know why you graded my answer a "c"
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show, step by step, how to integrate R code into a R Sweave document
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question