UserForm

[angushiro]

After creating a userform and testing it out with the VBA editor/ when it runs and all is completed successfully>
How do you save it to the present work book that you have named for this project?
thank you
Leo

[jwright650]

you can run the form by using .Show

ie. "UserForm1.Show" if your userform is named "UserForm1"

create a macro and assign it to a clickable object(I like to use a textbox pasted on the worksheet with the macro assigned to it) When you click on the textbox, it brings up the userform

[angushiro]

jwrite625

thank you very much for your support.
Leo

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save