Creating a pop-up timeline

**Nicolas Mous** · 04-26-2013, 04:25 AM

Hello All,

Since i discovered the magic world of VBA in Excel i wanti to use it for more and more possibilities. What i want to do now is creating a pop-up timeline in an excel sheet and my question is, is this possible and how can i do this the best? So what i got is a normal timeline with the month data in a row (march - arpil - may and so on) and the activity in a column. The activity duration is visible with different (filled cell) colors.

What i want to crate is a textline or button that can be pressed for example you got action 1, action 2, action 3 and a timeline that mathes the action pops-up.
I already experimented a bit with an userform (see attached document) but the problem with this is that it doesnt seem to detect colors.

Also dont mind the programming in the attached excel sheet since i only wanted to program action 1 but it also shows part of the other timelines.

Thx in advance!

**tehneXus** · 04-26-2013, 05:14 PM

Click Action 1 to see 2 suggestions. Map1test.xlsm

Regards

**Nicolas Mous** · 04-28-2013, 10:31 AM

Originally Posted by tehneXus

Click Action 1 to see 2 suggestions. Attachment 231341

Regards

Thx alot tehneXus! Just got a few questions. First of all what do the 'lvl1' and 'listform' in the useform and programing add? i just want to show the 'normal' color timeline, which can also be showed without those 2.

Second i want to know how i can show the other timeline's with new userforms. Which lines need to be adjusted? I try'd to adjust

Please Login or Register  to view this content.

but this doesnt see to work, i still shows the first timeline and not the timeline that starts in row 13.

Thx in advance and thank you for getting me this far!

**tehneXus** · 04-28-2013, 02:15 PM

Hi,

the ListBox is the one that was in your file already, i just left it there, the ListView "lv1" is the first example, if you don't need them -> delete.

About listbox/view: you cannot change the background color of a single item in VBA !

The 2nd solution is like a puzzle with labels created at runtime in loops.

Please download the latest version: Listbox and view are removed, if you want to change the range adapt the start row and start column at the beginning of the code.
Map1test_v2.0.xlsm

Regards

**Nicolas Mous** · 04-28-2013, 03:14 PM

Ah exactly what i assumed with the listbox and lv1

Thx alot for the help your really to awesome, cheers mate!

**Nicolas Mous** · 05-01-2013, 08:11 AM

Hello all, i stumbled upon 1 (last) little problem. In the posted example we were working out of 1 active sheet, the problem is that in my worksheet i got the timeline in sheet 3 and the action button in sheet 1. People cant see sheet 3 so i need to call the code and the timeline (that stands in sheet 3) in sheet 1 with the button. In the code i saw that 'active worksheet' was used which causes, when im in sheet 1, the timeline not to pick up the good timeline out of sheet 3. I try'd to adjust the active worksheet to sheet 3 but it doesnt seem to work, could anyone help me with this last little problem? Thx in advance!

The document: Testmap.xlsm

**tehneXus** · 05-02-2013, 01:38 PM

Hi,

try this one: Timelines_Labels.xlsm

If the worksheet name with the timelines will change adapt this in the code, other things to adapt are commented in the code.

Regards