Forum Discussion

Jakub180's avatar
Jakub180
Copper Contributor
Oct 26, 2023

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 done that time', 'client name', etc. I will be grateful for any advise!

 

 

  • JKPieterse's avatar
    JKPieterse
    Silver 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.
    • Jakub180's avatar
      Jakub180
      Copper Contributor
      Thank 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.
      • JKPieterse's avatar
        JKPieterse
        Silver 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.

Resources