problem with coding

Hi all

Please, can anybody let me know how to fix my problem.
I have a userform which has two textboxes where a user fills in the
startdate and an enddate.
The userform also has a listbox which is populated & loaded in a procedure.
Another procedure will process the dates, and selection from the Listbox.
and print it out.
However I would like to give the user the option of changing the dates by
using a command button that would use the AddDate method.
I am not sure where to place the code for this button as after the
UserForm_Intialize event has fired the user will not be able to change
these dates using the command buttons.

Any help would be greatly appreciated.

Kind Regards

Subs

Why wouldn't they be able to change these dates with commandbuttons?

--
Regards,
Tom Ogilvy

"Subs" <[email protected]> wrote in message
news:[email protected]...
> Hi all
>
> Please, can anybody let me know how to fix my problem.
> I have a userform which has two textboxes where a user fills in the
> startdate and an enddate.
> The userform also has a listbox which is populated & loaded in a
procedure.
> Another procedure will process the dates, and selection from the Listbox.
> and print it out.
> However I would like to give the user the option of changing the dates by
> using a command button that would use the AddDate method.
> I am not sure where to place the code for this button as after the
> UserForm_Intialize event has fired the user will not be able to change
> these dates using the command buttons.
>
> Any help would be greatly appreciated.
>
> Kind Regards
>
> Subs
>
>
>

Hi Tom

I think because when the program is running and the userform has loaded,
the program doesn't respond the click event associated with these buttons.

Regards
Subs

"Tom Ogilvy" <[email protected]> wrote in message
news:%[email protected]...
> Why wouldn't they be able to change these dates with commandbuttons?
>
> --
> Regards,
> Tom Ogilvy
>
> "Subs" <[email protected]> wrote in message
> news:[email protected]...
>> Hi all
>>
>> Please, can anybody let me know how to fix my problem.
>> I have a userform which has two textboxes where a user fills in the
>> startdate and an enddate.
>> The userform also has a listbox which is populated & loaded in a
> procedure.
>> Another procedure will process the dates, and selection from the Listbox.
>> and print it out.
>> However I would like to give the user the option of changing the dates by
>> using a command button that would use the AddDate method.
>> I am not sure where to place the code for this button as after the
>> UserForm_Intialize event has fired the user will not be able to change
>> these dates using the command buttons.
>>
>> Any help would be greatly appreciated.
>>
>> Kind Regards
>>
>> Subs
>>
>>
>>
>
>

If the commandbuttons are on the useform, they should.

If they are on the worksheet, then you would need to make the userform
non-modal (modeless)


--
Regards,
Tom Ogilvy

"Subs" <[email protected]> wrote in message
news:[email protected]...
> Hi Tom
>
> I think because when the program is running and the userform has loaded,
> the program doesn't respond the click event associated with these buttons.
>
> Regards
> Subs
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:%[email protected]...
> > Why wouldn't they be able to change these dates with commandbuttons?
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Subs" <[email protected]> wrote in message
> > news:[email protected]...
> >> Hi all
> >>
> >> Please, can anybody let me know how to fix my problem.
> >> I have a userform which has two textboxes where a user fills in the
> >> startdate and an enddate.
> >> The userform also has a listbox which is populated & loaded in a
> > procedure.
> >> Another procedure will process the dates, and selection from the
Listbox.
> >> and print it out.
> >> However I would like to give the user the option of changing the dates
by
> >> using a command button that would use the AddDate method.
> >> I am not sure where to place the code for this button as after the
> >> UserForm_Intialize event has fired the user will not be able to change
> >> these dates using the command buttons.
> >>
> >> Any help would be greatly appreciated.
> >>
> >> Kind Regards
> >>
> >> Subs
> >>
> >>
> >>
> >
> >
>
>

There on the userform, not on the worksheet,and their code is in the useform
code module. Should they be in a seperate standard module?

Regards
Subs

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> If the commandbuttons are on the useform, they should.
>
> If they are on the worksheet, then you would need to make the userform
> non-modal (modeless)
>
>
> --
> Regards,
> Tom Ogilvy
>
> "Subs" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Tom
>>
>> I think because when the program is running and the userform has loaded,
>> the program doesn't respond the click event associated with these
>> buttons.
>>
>> Regards
>> Subs
>>
>> "Tom Ogilvy" <[email protected]> wrote in message
>> news:%[email protected]...
>> > Why wouldn't they be able to change these dates with commandbuttons?
>> >
>> > --
>> > Regards,
>> > Tom Ogilvy
>> >
>> > "Subs" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Hi all
>> >>
>> >> Please, can anybody let me know how to fix my problem.
>> >> I have a userform which has two textboxes where a user fills in the
>> >> startdate and an enddate.
>> >> The userform also has a listbox which is populated & loaded in a
>> > procedure.
>> >> Another procedure will process the dates, and selection from the
> Listbox.
>> >> and print it out.
>> >> However I would like to give the user the option of changing the dates
> by
>> >> using a command button that would use the AddDate method.
>> >> I am not sure where to place the code for this button as after the
>> >> UserForm_Intialize event has fired the user will not be able to
>> >> change
>> >> these dates using the command buttons.
>> >>
>> >> Any help would be greatly appreciated.
>> >>
>> >> Kind Regards
>> >>
>> >> Subs
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
>

No. If you used the click event of the commandbutton (selected from the
dropdowns in the userform code module), then if you click the button, the
code should run. That is why controls have events - so the code will run
when the event is triggered.

--
Regards,
Tom Ogilvy


"Subs" <[email protected]> wrote in message
news:[email protected]...
> There on the userform, not on the worksheet,and their code is in the
useform
> code module. Should they be in a seperate standard module?
>
> Regards
> Subs
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:[email protected]...
> > If the commandbuttons are on the useform, they should.
> >
> > If they are on the worksheet, then you would need to make the userform
> > non-modal (modeless)
> >
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Subs" <[email protected]> wrote in message
> > news:[email protected]...
> >> Hi Tom
> >>
> >> I think because when the program is running and the userform has
loaded,
> >> the program doesn't respond the click event associated with these
> >> buttons.
> >>
> >> Regards
> >> Subs
> >>
> >> "Tom Ogilvy" <[email protected]> wrote in message
> >> news:%[email protected]...
> >> > Why wouldn't they be able to change these dates with commandbuttons?
> >> >
> >> > --
> >> > Regards,
> >> > Tom Ogilvy
> >> >
> >> > "Subs" <[email protected]> wrote in message
> >> > news:[email protected]...
> >> >> Hi all
> >> >>
> >> >> Please, can anybody let me know how to fix my problem.
> >> >> I have a userform which has two textboxes where a user fills in the
> >> >> startdate and an enddate.
> >> >> The userform also has a listbox which is populated & loaded in a
> >> > procedure.
> >> >> Another procedure will process the dates, and selection from the
> > Listbox.
> >> >> and print it out.
> >> >> However I would like to give the user the option of changing the
dates
> > by
> >> >> using a command button that would use the AddDate method.
> >> >> I am not sure where to place the code for this button as after the
> >> >> UserForm_Intialize event has fired the user will not be able to
> >> >> change
> >> >> these dates using the command buttons.
> >> >>
> >> >> Any help would be greatly appreciated.
> >> >>
> >> >> Kind Regards
> >> >>
> >> >> Subs
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>