Updating cells Q1 and R1 with start and end dates selected in a userform

**drewship** · 05-29-2009, 12:35 PM

Hello all,
I need some assistance taking dates entered in a userform and applying them to the sheet 'Completed_Report' cells Q1 and R1. The userform code that stores the input values is:

Please Login or Register  to view this content.

The start date selection is stored as 'txtInput.Text' and the end date is stored as 'txtInput2.Text'. Those 2 values are then converted to date format and stored in 'dtselect1' and 'dtselect2' respectively. I need sheet 'Completed_Report' cells Q1 and R1 to reflect these dates.

Thanks for your assistance!!

Andrew

**Kenneth Hobson** · 05-29-2009, 01:31 PM

Please Login or Register  to view this content.

I also recommend something like this:

Please Login or Register  to view this content.

Also, when using dates, convert the textbox strings to dates with CDATE() or convert them to dates by parsing the string for DATESERIAL(). Put this numeric value into your ranges instead of a date string. You can always add .NUMBERFORMAT to your range. e.g.

Please Login or Register  to view this content.

**drewship** · 06-01-2009, 07:13 AM

That worked!!! Thanks so much for all your help and information!!

Andrew

Updating cells Q1 and R1 with start and end dates selected in a userform

LinkBack

Thread Tools

Rate This Thread

Display

Updating cells Q1 and R1 with start and end dates selected in a userform

Re: Updating cells Q1 and R1 with start and end dates selected in a userform

Re: Updating cells Q1 and R1 with start and end dates selected in a userform

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions