Forum Discussion
Jakub180
Oct 26, 2023Copper Contributor
Excel Calendar - Info in pop-up window
Hello Guys, I am looking for a tip of how to prepare a calendar in excel where after clicking on cell - pop-up windows will show and I will be able to place some informations there like 'what was...
JKPieterse
Oct 26, 2023Silver Contributor
You would have to build this using VBA (or Office JavaScript) as there are no built-in tools for something like this. I think the first question to ask is whether doing custom development in Excel is the right choice for this or if you need a dedicated planning application (which might need tweaking too). Happy to help if you want assistance in creating something in Excel.
- Jakub180Oct 26, 2023Copper ContributorThank you very much for your reply! I think I will try with excel for now. Would be grate if you could tip any tutorials, etc. I have some basic background with coding.
- JKPieterseOct 26, 2023Silver Contributor
Jakub180 I would us e a userform to display and edit the data belonging to a selected item in (what looks like) your Gantt chart. You would need a separate table somewhere where you keep that information and the userform would read from and write to that table.