I'd like to have a message box appear when I run a macro that asks me if I want to use overdue OR due today OR due tomorrow OR due this week OR due this month.
Depending on the selection I'd like the macro to then filter a report in a certain way. I've created a YesNoCancel message box already and the code looks like this:
How could I change this to allow me to select one of the 5 options I mentioned at the top? Checkbox?
Please Login or Register to view this content.
Hello koltregaskes,
The easiest and most flexible solution is to create a UserForm. Place 5 buttons on the UserForm and have each button execute one of the five macros you have written.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I'm trying to avoid that if possible. Could the macro display a form itself? I see there is a frmMsgBox.MsgCstm command but upon quickly trying it I couldn't get it to work. Could I create a form using frmMsgBox.MsgCstm?
Why avoid the simplest solution? You can create a UserForm on the fly, but it's easier to create the form first
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Sample code to produce a userform with OptionButtons to run code
Please Login or Register to view this content.
Last edited by royUK; 06-29-2011 at 11:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks