bjfulkerson
asked on
Default to todays date on VB calendar
Private Sub Calendar1_Click()
TxtDate.Text = Calendar1.Value
End Sub
I am using this code for a calendar but I would like it to default to todays date
TxtDate.Text = Calendar1.Value
End Sub
I am using this code for a calendar but I would like it to default to todays date
And if you want the calendar to show today then
Calendar1.Value = Now()
Calendar1.Value = Now()
ASKER
Neither of these worked
Private Sub Calendar1_Click()
'TxtDate.Text = Calendar1.Value
'Calendar1.Value = Now()
TxtDate.Text = Now()
Private Sub Calendar1_Click()
'TxtDate.Text = Calendar1.Value
'Calendar1.Value = Now()
TxtDate.Text = Now()
ASKER
I still need to change the date when I select it on the calendar. These won't let me.
I also need to have any data in this text box to clear after the add key is selected
Private Sub TxtA_Change()
End Sub
I also need to have any data in this text box to clear after the add key is selected
Private Sub TxtA_Change()
End Sub
Can you attach your workbook and post a detailed explanation of what you are trying to do?
ASKER
Let me finish my work and I will upload it soon
ASKER
I have uploaded my workbook and a word doc with explanation.
Thanks in advance.
This-is-a-timesheet-entry-and-employee-u
StlFunction-Analisys-2015-v1c.xlsm
Thanks in advance.
This-is-a-timesheet-entry-and-employee-u
StlFunction-Analisys-2015-v1c.xlsm
I'm sorry but the workbook is too big for me to open. Here are some common ways to make it smaller. Or perhaps you could copy it and cut the copy down to just the parts that are needed to demonstrate the problem.
ASKER
Martin
It is much smaller now.
The Vlookup and the UPH calculation are no being carried down to the next ROW with a new entry
Thanks in advance
StlFunction-Analisys-2015-v1c.xlsm
It is much smaller now.
The Vlookup and the UPH calculation are no being carried down to the next ROW with a new entry
Thanks in advance
StlFunction-Analisys-2015-v1c.xlsm
Yes, that's much better:) I'll take a look at it and get back to you as soon as I can.
Your "explanation" document unpacked into some xml, etc files. Can you explain here what you expect to have happen?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
ASKER
This is a timesheet entry and employee update doc to track productivity.
1. I would like the cursor to start in the INITIALS box. Currently, when the initials are entered it auto pops the FNAME, LNAME, STATUS and HDEPT.
a. I would like the cursor to jump to the FUNCTION CODE box and using the tab to the A#, TIME, UNITS, ADD button.
b. After pressing enter when the ADD button is active, can the A# box be cleared?
2. All this data updates the Timesheet Tab
a. When I ADD, I get an error
Runtime error 424
the debugger highlights .Cells(lastrow + 1, "G").Value = TxtUPH.Text
Private Sub ccmdAdd_Click()
Dim lastrow As Long
With Sheets("Timesheet")
lastrow = .Range("A1048576").End(xlU p).Row
'lastrow = Sheets("Timesheet").Range( "A2").End( xlDown).Ro w
.Cells(lastrow + 1, "A").Value = ComboBox1.Text
.Cells(lastrow + 1, "B").Value = TxtDate.Text
.Cells(lastrow + 1, "C").Value = CB2FunctionCode.Text
.Cells(lastrow + 1, "D").Value = TxtA.Text
.Cells(lastrow + 1, "E").Value = TxtTime.Text
.Cells(lastrow + 1, "F").Value = TxtUnits.Text
.Cells(lastrow + 1, "G").Value = TxtUPH.Text
.Cells(lastrow + 1, "H").Value = TxtFname.Text
.Cells(lastrow + 1, "I").Value = TxtLName.Text
.Cells(lastrow + 1, "J").Value = TxtHDept.Text
End With
End Sub
b. When I enter a new line item through the TIME SHEET ENRTY it removes the functions that are in place. I have a VLOOKUP function in the DESCRIPTION column to add the description by the code entered and in UNITSperHR. It doesn’t update the rest of the information LNAME, FNAME and HDEPT. See row 35 and 36 for example.
Thanks for your time
Jody
1. I would like the cursor to start in the INITIALS box. Currently, when the initials are entered it auto pops the FNAME, LNAME, STATUS and HDEPT.
a. I would like the cursor to jump to the FUNCTION CODE box and using the tab to the A#, TIME, UNITS, ADD button.
b. After pressing enter when the ADD button is active, can the A# box be cleared?
2. All this data updates the Timesheet Tab
a. When I ADD, I get an error
Runtime error 424
the debugger highlights .Cells(lastrow + 1, "G").Value = TxtUPH.Text
Private Sub ccmdAdd_Click()
Dim lastrow As Long
With Sheets("Timesheet")
lastrow = .Range("A1048576").End(xlU
'lastrow = Sheets("Timesheet").Range(
.Cells(lastrow + 1, "A").Value = ComboBox1.Text
.Cells(lastrow + 1, "B").Value = TxtDate.Text
.Cells(lastrow + 1, "C").Value = CB2FunctionCode.Text
.Cells(lastrow + 1, "D").Value = TxtA.Text
.Cells(lastrow + 1, "E").Value = TxtTime.Text
.Cells(lastrow + 1, "F").Value = TxtUnits.Text
.Cells(lastrow + 1, "G").Value = TxtUPH.Text
.Cells(lastrow + 1, "H").Value = TxtFname.Text
.Cells(lastrow + 1, "I").Value = TxtLName.Text
.Cells(lastrow + 1, "J").Value = TxtHDept.Text
End With
End Sub
b. When I enter a new line item through the TIME SHEET ENRTY it removes the functions that are in place. I have a VLOOKUP function in the DESCRIPTION column to add the description by the code entered and in UNITSperHR. It doesn’t update the rest of the information LNAME, FNAME and HDEPT. See row 35 and 36 for example.
Thanks for your time
Jody
I'll be happy to help but this should be a new question.
TxtDate.Text = Now()