Відео

Great job mate! I needed it for userform and it works perfect. I just start exploring vba and have a question. I figure out how to highlight todays day in red but I have problem to highlight the labels in grey on the mouse move. Any chance you could do the video on customization and share your knowledge :). Thank you

Bro, you're a genius! I've been looking for a calendar like this for a long time, and only your version works as it should. Thank you so much for your hard work!!!

Only problem is that word searches always allow words to be placed diagonally. :-(

Thank you very much for your very useful video. I have a question. How can I change the order of the days of the week? For example, instead of Sunday, Monday is the first day shown on the left? Thank you.

Thank you very much for your very useful video. I have a question. How can I change the order of the days of the week? For example, instead of Sunday, Monday is the first day shown on the left? Thank you.

Can you write a code for returning the selected "Checkbox names" to the desired cells?

Wow, Very Professional. Thank you for shared your work

what is the name od the song?

I am using similar approach to have some other function, however the icon part is not clear to me. what is the right steps to convert the image into bmp then hex? or what is the best approach, please help

is excellent, the more high level in calendar for excel

Just found this now as I was looking for a clean way to put a calendar on our process from. Video is exceptional and I also downloaded the add in and made life a little easier. Thank you for BOTH.

Everything worked perfectly until I reached the last part where clicking on a date is supposed to fill in the cell automatically. It is not working😭 and I wrote all the codes similarly one by one as in this video. Plz help!!!! 😭😭😭

Hi, first of all thanks for the work on this great feature! It's a great addition, however, I've encountered a strange issue when using the date picker. After entering a date, the history for the undo is erased. Is there a fix for this? Thanks!

Cant use this with macros enabled.. do you need the macros?

hi, i have a 64bit edition of excel and really appreciate this video - i was following it all until we got to the MoveFormToMouse line, as soon as i add that, VBA highlights the ShowCal Sub line in yellow and throws an error.. where am i going wrong? also im a bit confused.. it seems after i import the add-in and put it in the xstart folder, when i click alt+f11, the datepickerform is already there, along with the api's and everything else so what is the userform1 for? is that the same thing? do i need to create a userform1 as well as having the 'datepickerform'? i dragged the date picker form over to the project with my current worksheet, and did the same for the other folders class and module.. now i think ive made a bit of a mess and have no idea if i should wipe the lot and start again, whether or not i should import the addin and use that or not bother with that and instead recreate a userform1 as you did in the first 8 mins or so of the video? sorry.. new to excel but really wanted a drop down date picker.. i dont know why Microsoft dont have one for the 64 bit edition and why they havnt bothered to make one - literally spent days just trying to create a drop down box when it couldve been done with a few clicks :( anyway, ive subbed because youre the only person so far whos even bothered addressing the issue for a 64bit edition any help would be greatly appreciated though - if you have a video which just shows what to do with the downloaded file, how to add the add in and use the vba stuff you already have within the downloaded files and what to drag where to get it to work, id really appreciate that, hopefully save me typing lots of code as i think that is really throwing me off - im bad enough with excel let alone coding on top of that :) many thanks

Thanks 💦💦

Hi do you have file for the module?

Thank you for this video. I followed your tutorial and I managed to create Date Picker.

1 little bug, whenever I click the first row or any column, I get a run-time error '1004'

how can I link this code to a range of cells and eliminate the button (one less click)

Thank you so much for this! Very helpful! What if we wish to show say the whole year's calendar on the same worksheet? Is it possible

Thank you! Very useful, and I could install it easily thanks to you instructions. Much appreciated!

thank you

Does it work in excel for Mac?

Hi! May I know why my workbook auto close while implementating the project. Thanks. I don't know if this is a bug or not.

Super thanks to you!!!! Great stuff.

Nice. The symbol is printed. Can this be prevented?

Will this work if i send my excel file to another user overseas? they likely will not be able to download anything into workstations

Hi is it possible to use this to find a specific date on the sheer?

Hi, awesome work, use it all the time. If possible can you add code to change screens? As I move from left screen to right screen the calander pops up on left screen at the bottom. Any help appreciated

This is so helpful! Thank you!

Hi there, this is great. i downloaded it to one of my laptops, it worked perfectly, but when i sent this file to another laptop , it wont work, error message shows cant find project something wrong with this code : pathToIcon = Environ("temp") & "\samrad3.bmp" the Environ function. Please help!!!!!!!!!!!!!!

Humanity is grateful to you. Great job!

This will put a box around whichever day is selected or it will default and put a box around todays date..... Dim DAYorNOW As Date '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' If VBA.IsDate(ActiveCell.Value) Then trackingDate = ActiveCell.Value Else trackingDate = Format(Now, "mm/dd/yyyy") 'Added to keep trackingDate format consistent. End If DAYorNOW = trackingDate 'Added to capture original trackingDate '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' With cDay .Caption = VBA.Day(trackingDate) .Tag = trackingDate If DAYorNOW = trackingDate Then .BorderStyle = fmBorderStyleSingle .BorderColor = RGB(0, 0, 0) Else .BorderStyle = fmBorderStyleNone End If If VBA.Month(trackingDate) <> iMonth Then .ForeColor = 8421504 trackingDate = VBA.DateAdd("d", 1, trackingDate) End With

thanks !

Quite Impressive. I am using both the cell and form versions. Just had to change the textbox name and the top postion of the frame and it works perfectly. Thanks so much. Very easy to use.

Ive been doing VBA/Excel almost day to day for 10 years and this just proves there's still more to learn. I had a different idea but this was so elegantly and wonderfully presented I didn't see any other reason to try and homebrew my own idea. This was a wonderful tutorial and creativity for this solution was off the charts. Great stuff man.

Hi Sam , I use the Data Picker add-in in my excel application. Thank you very much. But I have a problem, the plugin accepts "Sunday" as the first day of the week. Is there a way to change it to "Monday"? Can you help with this?

Time 0:22 I keep getting a Extra Excel Sheet. - SHOW FORM. open up everytime & when I close my Sheet this Sheet still remains & have close it :( How do I disable it PLEASE HELP

So far I watched three calendar VBA video's yours is by far the best, thank you, and great work!

I need help deleting a VBA Project I downloaded from you. Please how can I contact you for information

Hey. Many thanks for this great plug-in. One problem: Today is Friday 5.04.2024, Datepicler shows Saturday 05.04.2024. The wrong day of the week. Mysterious.

The site link is broken.

Can this picker be used in a form?

Outstanding work!

You should finish the tutorial.

Hi Sam, I use your 'fake data' add-in. it is saved in my startup folder. file properties unblocked. I am running into an issue with 'stock animated objects' Excel/Insert/3D models/Stock 3d models. The animation is blocked in Excel when this add-in is installed as soon as I restart Excel without the add-in loaded then these stock objects work correctly. Any thoughts?

excelente video

Many many thanks

Дякую!!!! Просто і ефективно у викристанні. СУПЕР