De Premor,
I like your solution.
This is an opportunity for me to learn new tips and polish my VBA skills. I
will attempt to combine yours and Paul's;
Next step would be to try to 'merge' my userforms.
Instead of having 1 userform for data entry and another for search,I am
thinking of using:
a mu
Hi All,
I've writen a code for this case, i use a junk sheet for removing
duplicate and sorting, it seem more easy to use, much faster, flexyble,
and cut off unneeded code
what i've done is on form initialize is : copy date to junk sheet,
remove the duplicate, sort it, and place it on combo
>>
>>Then, when you search, it compares the dates of the records to these two
>>dates and loads the listbox.
>>(which I also have happen when the End Date combobox is changed)
>>
>>Your macros are about 215 executable lines of code(excluding blank lines)
>&g
dn't incororate my original solution to your latest file, but I can if
> you wish.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At
___
> From: Awal
>To: excel-macros@googlegroups.com
>Sent: Wednesday, October 15, 2014 8:17 PM
>Subject: $$Excel-Macros$$ Re: Item search in Userform
>
>
>
>Paul,
>I loaded all the available Begin Dates into the Begin Date combobox.
>>I cr
Paul,
> I loaded all the available Begin Dates into the Begin Date combobox.
> I created a change event in which when you select a begin date,
> all the available dates AFTER that date are loaded into the End box
> (no sense making it possible to select an end date that occurs BEFORE the
> begin
Attached is what I've done thus far.
Regards
On Wednesday, October 15, 2014 12:23:17 PM UTC-4, Awal wrote:
>
> Hello,
> With a Userform, I would like to search a database, display the result of
> the search in the form and be able to print it out. See screen shot below.
> I am attaching a sampl