Hi,
Please can any excel expert help me on the below problem:
Input:-
There is a button in my sheet which will open User Form that takes following inputs :-
a) start date (textBox with the name txtStartDate) and end date(textBox with the name txtEndDate) in dd/mm/yyyy format.
b)TeamName( lstTeam - listbox which allows users to take one or more teams)
c) Level ( listbox with only 1 selection having name lstLevel)
One button named "Submit" .
On clicking submit, I want the code to perform below functionality in else block of the code.
--------------------------------------------------------
Private Sub btnReport_Click()
Dim abc As Date
Sheets(" Sheet1").Activate
If ((Len(Me.txtStartDate.Value) = Empty) Or (Len(Me.txtEndDate.Value) = Empty) Or (Len(Me.txtSave.Value) = Empty) Or (Me.lstBoxReport.ListIndex = 0) Or ((Me.lxtBoxLevel.Value) = Empty)) Then
MsgBox "Please enter all the values "
Else:
Exit Sub
End If
End Sub
---------------------------------------------------------
Functionality :
Please find the sample attached sheet..
In the sheet you will find set of names with the tracker stating who all did projects i.e. the calendar having entry as P/P1 ETC.., now I want is when I select the dates and the input data from the form for example date 28/10/2014 to 04/11/2014 , team - SCM , LEVEL-ALL( means all the groups), I get the names of the person those who worked on the project in that period in another sheet, here sheet 2.
------------------
Please can any excel expert help on this. I need this on urgent basis.
regards,
natasha
Bookmarks