change start and end date based on userform entry

[stoey]

hi guys,

i have this following code on my file

Please Login or Register  to view this content.

what i want to accomplish is...i want to have a userform which has 2 textbox for start and end date...and an "ok" button for the changes to take effect. the userform will work in such a way that if the user enters 2014-05-11 for the "start date" and 2014-05-12 for the "end date" then hitting the "ok" button will change the dates from the code above...anyone has the idea on how to accomplish this? thanks in advance...

also the userform should appear first once the workbook is launched.

[ranman256]

Less complicated way, You dont HAVE to use a userform. I use cells for the values say: B1, and B2 (with labels in A1, A2 for StartDate, EndDate)
Put a button on the screen run your macro above.

[stoey]

Less complicated way, You dont HAVE to use a userform. I use cells for the values say: B1, and B2 (with labels in A1, A2 for StartDate, EndDate)
Put a button on the screen run your macro above.

hi ranman,

thanks for the quick reply...i know how to do that but i just want to do a different thing which is needed for the program...any idea how to do this??