Need calendar dropdown or pop up box for a column
Hey i am using exel 2013 and have a master worksheet which has a date column
the problem is i have to insert different dates in each cell of the particular column but it takes too long to manually do it, i need the cell to automatically give me a calendar pop up or drop down calendar but i cannot figure out how to do this.
im using Microsoft date and time picker
thanks
someone help plz
Try this. I've followed the instructions and it works.
Its time consuming to watch (3 seperate videos) and get the handle on it but, keep at it.... Good luck!
Here are the three parts:
https://www.youtube.com/watch?v=HoLnieD3R04
https://www.youtube.com/watch?v=X0Q5ebOQ2yg
https://www.youtube.com/watch?v=OCLfoaCzvsI
thanks for the reply will check it out and see if it can solve my problem
I do need some help though regarding some stuff that's complex (to me at least)
To understand my problem ill give some more details:
I'm an Advocate and work with around 10 other Advocates and as of now we keep all matters in our diaries but it is getting difficult to keep track of everything so i decided to create a excel sheet with all the clients and the dates for their matters now i am going to create a userform to make data entry n edit easy but the dates are difficult to sort because we have previous date, current date (date on which the matter is) and next date. Now when updating a case the current date will become the previous date and the next date will become the current date but i cannot figure out how to do this also all matters are either in the morning of evening.
Now i need help to shift the dates in the work sheet automatically when i update a case number of the client.
Secondly i also need an easy way to enter dates in the cells instead of typing them manually.(this may have been answered by Johfra)
thanks
Last edited by uglymaggot; 07-13-2014 at 11:20 PM.
Hi uglymaggot
Welcome to the Forum!!
See this Link for a Free Database Form which I believe will serve your purposes wonderfully well.
http://www.excel-it.com/excel_databaseform.html
There is no Calendar Control in the Code but that's easily incorporated. If you're interested I'll help. It may be a long ride but I believe you'll enjoy it.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Johfa thanks for the input but the calender video you mentioned does not suit my needs but thanks for the help.
jaslake ill check it out and see how it goes and im pretty sure im gonna need help with the VBA stuff ive done what i can but i think ive chosen something lil complicated any help would be much appreciated.
Hi uglymaggot
You get her started, get the Data File designed and populated (with dummy data), work on the Code as you're able. Holler when you need help...be glad to assist.
well ive already gotten everything designed like the macros, one advanced filter and the dashboard design is complete will definitely require help with mst of the code will bug u about stuff very soon
thanks
Hi uglymaggot
Whenever you're readywill bug u about stuff very soon
hey ok ive reached a roadblock ill paste the code below
The code is for a listbox where i can select the desired row and it gets placed into controls in the userform the issue im heving is i can only select the first row if i select any other row i get an error 91 any thoughts on how to solve this problem.PHP Code:Private Sub lookupdata_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
'declare the variables
Dim File As String
Dim I As Integer
Dim findvalue
'error block
On Error GoTo errHandler:
'get the select value from the listbox
For I = 0 To lookupdata.ListCount + 1
If lookupdata.Selected(I) = True Then
'set the listbox column
File = lookupdata.List(13, I)
End If
Next I
'find the value in the range
Set findvalue = Sheet3.Range("B:B").Find(What:=File, LookIn:=xlValues).Offset(-13, 0)
'add the values to the userform controls
cNum = 14
For X = 1 To cNum
Me.Controls("reg" & X).Value = findvalue
Set findvalue = findvalue.Offset(0, 1)
Next
'disable the controls to make the user select an option
'error block
On Error GoTo 0
Exit Sub
errHandler::
MsgBox "An Error has Occurred " & vbCrLf & "The error number is: " _
& Err.Number & vbCrLf & Err.Description & vbCrLf & _
"Please notify the administrator"
End Sub
Hi uglymaggot
Sorry, the Code without the Workbook is not something I'll be able to assist with. I need to see what the Code is doing based on my presumption of what it is you wish it to do.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and, if appropriate to the Issue, an "After" worksheet that demonstrates what you wish the output to be.
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.
Try the attached. The calendar will pop up with a double click for any cell that has a date format.
Hey guys thanks for the help
I dont get much time to work on the project so its going slow inspite of that i still got alot done.
I managed to solve the earlier problem i had just put in the wrong rows, columns in the vba code.
1) A problem im not able to solve is why my textbox that shows a date wont show it in the correct format the code in vba is:
but the textbox shows the date as mm/dd/yy even though my excel sheet date format is also dd/mmm/yyy.PHP Code:.offset(0,5).value = format (nxtdt.value, "dd/mmm/yy")
2) I set up my userform to have a date picker on it but i need help to put the selected date (double clicked) into the selected textboxes for the dates.
A big Problem
I realised a future problem that will indeed cause me great trouble: the userform is for use by 10 persons who are spread across 2 offices and hence i would need a way to allow them to all access the file and update it using the userform from their own computers.
Hence i would require to sync the main sheet with all the individual sheets so that everyone has the most updated version.any ideas. And yup it would have to sync over the net and preferably with a sync button on the userform to auto sync the file.
A big thanks to guitarsweety for the sheet with the double click date it is just what i was looking for when i first posted and i think i might have a use for it and jaslake for dealing with my erratic behaviour and still wanting to help.
Last edited by uglymaggot; 08-02-2014 at 06:44 AM.
Encountered a major problem with my double click event
the issue is i cannot select an updated item im guessing because it has the same file no. i need to solve this as it is vital for me to select the most updated item without deleting the previous entries.
Here is my excel sheet with the code:
diary test current.xlsm
problem solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks