Creating a userform? That would have 3 buttons and inputs would control the macro?

**Mr_Bill** · 08-27-2014, 11:01 PM

Okay firstly sorry if I have the wrong terms I have been searching for a while to find a solution and not much luck I figured out how to add a userform and put buttons on it and that is it. An amazing person on this forum made me a macro and gave me this little extra to have a couple buttons

Please Login or Register  to view this content.

I am wondering is it possible to have this edited or changed so I could have something that would have the title of the popup be "Grade Sorting Options" and have three buttons labeled Ascending, Descending and Cancel? The Ascending and Descending if I read that code right would input true or false depending which is clicked. The cancel would just close the popup. Is this something someone could help me with please.

Thank you,
Bill

**pmyk** · 08-28-2014, 01:03 AM

There are several easy to learn tutorials with screen shots, video by which you can easily learn how to create userform and put on it controls like commandbutton, label etc.,
The following Popup may help you.

Please Login or Register  to view this content.

**Mr_Bill** · 08-28-2014, 01:34 AM

okay thank you I will continue to search for a tutorial that shows me how to make a popup with custom names on the buttons. Just wasnt having any luck all the ones I found had input fields and than click a button.

**pmyk** · 08-28-2014, 04:14 AM

An Userform can serve that purpose. Once the desired CommandButton is chosen, that Userform can be hidden and the corresponding code can run another Userform or whatever.
Try this:
In UserForm1 you should have three command buttons.
In UserForm1 you can have a label with the caption: "Grade Sorting Options"
You should have Userform2 also.

Please Login or Register  to view this content.

In Userform2 you can have this code:

Please Login or Register  to view this content.

In the ThisWorkBook, you can have this code. This will bring the popup when you open the workbook.

Please Login or Register  to view this content.

**Mr_Bill** · 08-28-2014, 12:41 PM

okay thank you for trying again. no idea what all the extra stuff is in these. I was trying to make the current form I have a bit easier. I will just keep what I have just wanted custom names on the buttons instead of a yes and no.

Creating a userform? That would have 3 buttons and inputs would control the macro?

LinkBack

Thread Tools

Rate This Thread

Display

Creating a userform? That would have 3 buttons and inputs would control the macro?

Re: Creating a userform? That would have 3 buttons and inputs would control the macro?

Re: Creating a userform? That would have 3 buttons and inputs would control the macro?

Re: Creating a userform? That would have 3 buttons and inputs would control the macro?

Re: Creating a userform? That would have 3 buttons and inputs would control the macro?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Employee sign-in userform - Creating error messages for incorrect inputs?

[SOLVED] Creating a for loop with command buttons in a userform

2 Control buttons, 1 UserForm, Reference 2 Columns

Creating a Macro to Draw a single stacked column graph with variable inputs

[SOLVED] No control for option buttons, invisible macro??

Bookmarks

Bookmarks

Posting Permissions