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
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?
Code:
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?