Date and day in User Form 
Author Message
 Date and day in User Form

This is a Excel 2002 Visual Basic User Form

 I have Following UserForm

 Lable Date User enter's Date in TexBox1
 Label Day It should calculate day E.G. "WED" depndon date entered in
 TextBox1 and dispay the day Without Edit Option

 After Verifying the date in Table "Year" input rest of the data in Table
 "Year" it has same lables and fields

 I have atteched Data_Entry.frm file with this message




Thu, 08 Jul 2004 03:07:14 GMT  
 Date and day in User Form
I have Excel Worksheet Named "Data" there is named range called "Date1"
Data:A2 To Data:A366 with Label "Date"
in that range ther are dates from 1/1/2002 To 12/31/2002 Right of that
column Data:B2 column and Data:I366 rows named range called "Year"
With Row 1 with following Label

Date Day Shift # 1 Customer Count # 1 Shift # 2 Customer Count # 2 Gross
Sales Tax Cash Expanse

Now the task is From UserForm1 there are same field with Labels and
TextBox's whene user fills the date in Date1_TextBox Day should be
automataclly caculated and appear in Day_Label and after user fills up rest
of the TextBox's with Shift # 1 and ETC.. data should goto Worksheet "Data"
VERIFYING Or MATCHING the Date With Date in Named Range "Date1" in the
Worksheet "Data" and Put the data in corsponding date's row so data will be
for purticular date not like NextRow OR CurrentRow

I really appricate you are respondiong to my questions




Fri, 09 Jul 2004 02:59:01 GMT  
 Date and day in User Form
Perry,

Sending your posts direct to individuals who have posted responses in the
newsgroup is not going to help your cause.  Stating your question clearly
and consicely will.  Those of us who respond to queries in the newsgroups do
so on a voluntary basis, and in often our own time.  If you receive no
response in the group, it's because we don't have an answer.

Please do not mail directly unless invited.

Alan P.


Quote:
> I have Excel Worksheet Named "Data" there is named range called "Date1"
> Data:A2 To Data:A366 with Label "Date"
> in that range ther are dates from 1/1/2002 To 12/31/2002 Right of that
> column Data:B2 column and Data:I366 rows named range called "Year"
> With Row 1 with following Label

> Date Day Shift # 1 Customer Count # 1 Shift # 2 Customer Count # 2 Gross
> Sales Tax Cash Expanse

> Now the task is From UserForm1 there are same field with Labels and
> TextBox's whene user fills the date in Date1_TextBox Day should be
> automataclly caculated and appear in Day_Label and after user fills up
rest
> of the TextBox's with Shift # 1 and ETC.. data should goto Worksheet
"Data"
> VERIFYING Or MATCHING the Date With Date in Named Range "Date1" in the
> Worksheet "Data" and Put the data in corsponding date's row so data will
be
> for purticular date not like NextRow OR CurrentRow

> I really appricate you are respondiong to my questions





Fri, 09 Jul 2004 05:09:52 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Date Field on Form to automatically update with current days date

2. Need Date Formula from start date to 120 days later to calculate new date

3. Looking for a date function that doesn't change day to day

4. Determine if date is between Day 1 and Day 2

5. Making Days read as DAYS and not DATES

6. Day view only shows date not day too

7. how to highlight the (date) object in form when birthday (last 14 days before birthday)

8. Auto date and day, month, year totals on form

9. Calendar in a form to display current day and date

10. Adding 7 days to Form Date


 
Powered by phpBB® Forum Software © phpBB Group