Hello,
I have a ListBox1 that is populated with Dates.
I want to be able to assign a macro to a CommandButton that selects Quarter 1 dates for 2013. I wrote something like this:
It doesn't error, it just doesn't work. The code should select all values in the ListBox1 1/1/2013-3/31/2013
Please Login or Register to view this content.
I don't understand how to select a YEAR & MONTH to run through a loop and select.
Last edited by EnigmaMatter; 03-07-2014 at 09:46 AM.
Hello EnigmaMatter,
There may be many reasons why this code is failing. To get an answer to this problem quickly, you should post a copy of your workbook.
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!)
Okay.
I have attached an Example with the following code:
Please Login or Register to view this content.
Edit: Workbook attached in first post.
Last edited by stnkynts; 03-06-2014 at 06:30 PM.
Yeah, I couldn't figure out how to attach it to my reply post.
Hello EnigmaMatter,
The statement ListBox1.Selected(I) is a boolean value that tells you if the ListBox item was selected. Where do you want the Year, Month, and Day to go?
Hello Leith Ross,
I don't want it to go anywhere, I just want the button to select the dates 1/1/2013-3/31/2013.
I will then execute a macro on all selected items.
Hello EnigmaMatter,
The button's caption says "Select A1/1/2013-3/31/2013" and now you are saying you want the button to select these cells??? Can you explain step by step what the user is to do on this worksheet?
I apologize...the "A" in front of the caption is a typo.
When the User presses the CommandButton...every selection choice from 1/1/2013 to 3/31/2013 will be selected in ListBox1. I want it to select the ListBox items not the Cells.
Nothing else happens.
Hello
This macro will compare the dates in the user has selected in column "A" and set the item in the ListBox if the dates match.
Please Login or Register to view this content.
Last edited by Leith Ross; 03-06-2014 at 07:27 PM.
Hello EnigmaMatter,
I just made a change to prevent an error if the user selects only a single cell. This version will prevent that from happening.
Please Login or Register to view this content.
This will select the first quarter in 2013.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hello All,
Thanks for the replies.
I am trying Norie's solution...but when I adapt for my UserForm, it doesn't quite work.
Please Login or Register to view this content.
Last edited by EnigmaMatter; 03-07-2014 at 09:07 AM.
I apologize for the multiple edits.
The code above does in fact not work, though it does not error.
Last edited by EnigmaMatter; 03-07-2014 at 08:44 AM.
How does it not work?
Can you upload the file with the userform?
Norie,
Sure. Hang on, I need to make an Example file.
What is Listbox1 in this code?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Izandol
Listbox1 was a listbox on a worksheet in the original attachment.
When I look before, code posted was:
It is different now.Please Login or Register to view this content.
See what you mean now, didn't spot that myself.
Norie, Izandol,
I have posted an example Workbook that contains Norie's code to the original post.
Why did you attach it to the original post?
I didn't realize I could post an attachment to any post. I am still learning my way around this forum, and forums in general.
It's attached here now.
I think this is a date formatting problem.
Can you expand on that?
You may try:
Please Login or Register to view this content.
Izandol,
This works in the example, and I will test in my UserForm later.
Thanks to you, Norie, and everyone else who contributed.
It works in my UserForm!
I just had to use this part with different object references:
I will be looking up CDate now...Please Login or Register to view this content.
Izandol
When I try that code, and my own similar code, it seems like the date formatting isn't quite right - for me anyway
For example, the next item after 12/1/2013 is 1/13/2013
That's followed by 1/14/2013 and continues on in the same format up to 1/31/2013.
@Norie
I too have this problem but I think OP is in USA so will not have it.
For me I will do this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks