View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Subs Subs is offline
external usenet poster
 
Posts: 15
Default problem with coding

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" wrote in message
...
Why wouldn't they be able to change these dates with commandbuttons?

--
Regards,
Tom Ogilvy

"Subs" wrote in message
...
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