Sub to call a Private Sub saved as a UserForm

[daveb86]

I am currently trying to setup an advanced employee management dashboard in excel

However i am encountering a few issues that i hope someone can help with ...

I have created a shapes in a worksheet and assigned the below macro to it

Please Login or Register  to view this content.

The macro i am trying to call is a Private Sub which is saved in the UserForm part of the VBA Window

But when i click the shape / button it just takes me to the next sheet instead of executing the form ... How can i achieve this ?

Please Login or Register  to view this content.

[Norie]

Is the form open when you try this?

[daveb86]

Yes .. If the form isnt open then i am unable to execute the script

The script is currently running behind the UserForm and as such is not saved in a Worksheet or Module

Therefore when i right click my buttons i am unable to assign the macro to the button as the script is within the UserForms Code and is also a Private Sub

How can i make this work ?

Thanks

Dave

[Norie]

Dave

Why do you want to call the sub from a shape on the worksheet?

Can't you use the cmdProcess button on the userform?

Am I missing something?

[daveb86]

Dave

Why do you want to call the sub from a shape on the worksheet?

Can't you use the cmdProcess button on the userform?

Am I missing something?

In that case how do i get the userform to appear in a worksheet ?

[daveb86]

Dave

Why do you want to call the sub from a shape on the worksheet?

Can't you use the cmdProcess button on the userform?

Am I missing something?

In that case how do i get the userform to appear in a worksheet ?

[Norie]

To show a userform the code would look like this.

Please Login or Register  to view this content.

So to show UserForm1 it would be this.

Please Login or Register  to view this content.

However I thought the was open.

[daveb86]

To show a userform the code would look like this.

Please Login or Register  to view this content.

So to show UserForm1 it would be this.

Please Login or Register  to view this content.

However I thought the was open.

When i put that code into the Sheets code it appears as a pop up

How do i make the form appear as though it was embedded in the worksheet ?

[Norie]

You can't embed a userform in a worksheet.

Do you still want to interact with the worksheet while the userform is displayed?

[daveb86]

You can't embed a userform in a worksheet.

Do you still want to interact with the worksheet while the userform is displayed?

Basically what im trying to do is build a performance management dashboard..

The section i was working on was to add a new employee which you would press the "Add Employee" button then a box would appear

In this box you would have 3 labels and 3 text boxes ..

Label 1 - Employee Name
Label 2 - Department
Label 3 - Line Manager

The Process button once pressed when the 3 text boxes where filled in would then paste the data into columns A, B and C on the next empty row in a certain sheet.

[Norie]

If that's what you want to do I don't see why you would want/need to call the Click event of the proceed button on the form.

All you should really have in the code for the shape is code to show the userform.

Once the user form is up and running it can take care of the rest.