I have a UserForm that displays calculated values from my worksheet…select the date from ComboBox1 and the values for that date are displayed in several Textboxes.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I’d really like to produce a replacement UserForm that displays Month-to-date and Year-to-date values<o></o>
<o></o>
I’ve started with this to select the dates<o></o>
<o></o>
<o></o>
So, I select the beginning date with ComboBox1 and the ending date with Combobox2.<o></o>
<o></o>
I’m looking for suggestions on how to Autofilter the worksheet based on the selections…<o></o>
<o></o>
I’d really like to produce a replacement UserForm that displays Month-to-date and Year-to-date values<o></o>
<o></o>
I’ve started with this to select the dates<o></o>
<o></o>
Code:
[FONT=Verdana][SIZE=1]Private Sub UserForm_Initialize()[/SIZE][/FONT]
[FONT=Verdana][SIZE=1]Dim x&<o:p></o:p>[/SIZE][/FONT]
[FONT=Verdana][SIZE=1]With Sheets("Sheet1")<o:p></o:p>[/SIZE][/FONT]
[FONT=Verdana][SIZE=1]For x = 2 To .Cells(Rows.Count, "A").End(xlUp).Row<o:p></o:p>[/SIZE][/FONT]
[FONT=Verdana][SIZE=1][I]ComboBox1.AddItem (.Range("A" & x).Value)[/I][/SIZE][/FONT]
[FONT=Verdana][SIZE=1][I]ComboBox2.AddItem (.Range("A" & x).Value)[/I]<o:p></o:p>[/SIZE][/FONT]
[FONT=Verdana][SIZE=1]Next x<o:p></o:p>[/SIZE][/FONT]
[FONT=Verdana][SIZE=1]End With<o:p></o:p>[/SIZE][/FONT]
[FONT=Verdana][SIZE=1]End Sub[/SIZE][/FONT]
So, I select the beginning date with ComboBox1 and the ending date with Combobox2.<o></o>
<o></o>
I’m looking for suggestions on how to Autofilter the worksheet based on the selections…<o></o>