Userform help needed to replace current one with a newer one

[DeezNuts]

I currently have one built with the macro that control true or false output but want to customize it a bit and cant see how current piece of code for the form is

    If MsgBox("Do you want to sort grades ascending or descending?" & vbCrLf & vbCrLf & "Click [Yes] for ascending" & vbCrLf & "Click [No] for descending", vbYesNo, "Sort by?") = vbYes Then
        sortAscending = True
    Else
        sortAscending = False
    End If
<code></code>

How would I go about making it look like this

With the output of true or false to control the macro.


Also instead of a short cut key is there a way to add a button or link to a sheet to activate the macro popup?

 

[DeezNuts]

Thank you so much for putting in all this time and resolving the issue I appreciate it.

 

[My Aswer Is This]

DeezNuts:

Were you able to get this to work with a Userform? If yes show me how you did this. Show me the code in the Userform and the module please.

 

[DeezNuts]

I will put together a file and upload it for you. I went a slightly different route using 6 arrow buttons so I can sort any one of three columns instead of just the one.

 

[DeezNuts]

here is a working version DropBox Example File I put a button on the sheet so didnt have to open the macro option screen

 

[My Aswer Is This]

That looks great. In case you do not know you can also assign a macro to run if you click on a particular cell. Or you can choose to run a macro from a list of macros from a dropdown list on your worksheet. If you want to know how to do this let me know. This will keep from having six shapes or buttons on your sheet.</SPAN>

 

[DeezNuts]

sounds good thank you here is how it looks with the images for the buttons

I also have this thread I am trying to change the start and end columns http://www.mrexcel.com/forum/excel-questions/802557-modify-macro-have-startcol-endcol.html

 

[My Aswer Is This]

That looks really great. Your buttons look good like that. I think we have all learned a few things here.

 

[Fluff]

Thank you so much for putting in all this time and resolving the issue I appreciate it.

Not a problem, glad to be able to help.