Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 36
  • Last Modified:

UserForm activated by a Button in a workbook

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
bjfulkerson
Asked:
bjfulkerson
  • 5
  • 4
1 Solution
 
NorieCommented:
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
 
bjfulkersonAuthor Commented:
I have what you said but it wont open the userform.
0
 
NorieCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
bjfulkersonAuthor Commented:
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
 
bjfulkersonAuthor Commented:
How do I use the ADD, UPDATE  and Delete
0
 
NorieCommented:
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
 
bjfulkersonAuthor Commented:
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
 
NorieCommented:
Add what information where?

The userform has various other textboxes that don't seem to match to anything on the employee sheet.
0
 
bjfulkersonAuthor Commented:
I will have to get back in the morning.
0
 
Martin LissRetired ProgrammerCommented:
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now