Solved

UserForm activated by a Button in a workbook

Posted on 2014-12-16
11
32 Views
Last Modified: 2015-01-13
I have a working user form.  I want to create a button on the HOME sheet of my workbook to click to launch the User Form
0
Comment
Question by:bjfulkerson
[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
  • 5
  • 4
11 Comments
 
LVL 34

Expert Comment

by:Norie
ID: 40503230
That's straightforward, goto the Home sheet, then goto the Developer tab and in the Controls section click Insert.

Now choose either a Forms command button or a ActiveX comman button and place it wherever you want on the sheet.

If you picked a Forms control you should automatically see the Macros dialog box.

Just click New and you should then see something like this.
Sub Button2_Click()

End Sub

Open in new window

This is where the code goes to open the userform, and here's the code.
TimeSheetEntry.Show

Open in new window

After adding that code this is what you should have.
Sub Button2_Click()
    TimeSheetEntry.Show ' open userform
End Sub

Open in new window


If you added an ActiveX button double click the button.

You should then see something like this, and this is where the code to open the form should go.
Private Sub CommandButton1_Click()
    TimeSheetEntry.Show ' open userform
End Sub

Open in new window

0
 

Author Comment

by:bjfulkerson
ID: 40503366
I have what you said but it wont open the userform.
0
 
LVL 34

Accepted Solution

by:
Norie earned 500 total points
ID: 40503392
I added it to the previous workbook, and added buttons to the userform, though they don't do anything at the moment.

See the attachment.
STL-Function-Analysis-2015-V2.xlsm
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:bjfulkerson
ID: 40503407
You left a box in the upper left of the home page.  It crashes when I try to delete.

Do you know anything about adding a pop up calendar so I can select a date in the past or future?
0
 

Author Comment

by:bjfulkerson
ID: 40503409
How do I use the ADD, UPDATE  and Delete
0
 
LVL 34

Expert Comment

by:Norie
ID: 40503416
It depends what you want to do with them really, which at the moment I don't know.:)

PS That 'box' was in the original file you uploaded.
0
 

Author Comment

by:bjfulkerson
ID: 40503460
What I want to do is "add" the information added to the worksheet form (next available ROW.

Eventually I will want to duplicate this button to update employee information and update codes.
0
 
LVL 34

Expert Comment

by:Norie
ID: 40503486
Add what information where?

The userform has various other textboxes that don't seem to match to anything on the employee sheet.
0
 

Author Comment

by:bjfulkerson
ID: 40503517
I will have to get back in the morning.
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 40546271
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

627 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