Belonging Row is not clear in Code

**Julian Schubert** · 06-22-2011, 04:09 AM

Hi @ all,

I have the following Code

Please Login or Register  to view this content.

Situation:

This code marks given events in "K" in a timeline at the right place in the year - okay!
But unfortunately it does not only mark the given date (inrow "k") in the timeline. It marks the whole timeline...

Would you be so kind to adopt the code that only the date which is given in row "K" is marked?
It is not necessary to mark a period. It should just show what is in row "K".

Thank you in advance from Germany

**snb** · 06-22-2011, 04:21 AM

I think that by using the debugging tool in the VBEditor you will be perfectly able to see what the code does and to improve it. Especially when applied to the workbook with real data (that we haven't been provided with).
Better than asking for a solution is acquiring the means, methods and ability to solve problems yourself.

**arthurbr** · 06-22-2011, 05:00 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

**watersev** · 06-22-2011, 05:54 AM

hi, Julian Schubert, you compare each value in Sheets("Sheet1").Range("A4:NB4") with k and k.Offset(0, -1), what is the condition for colouring k?

**Julian Schubert** · 06-22-2011, 07:23 AM

Hello Waterserv,

find attached the file.
I think it is easier to look at it than to describe it.

The aim is that the code automatically looks at row "K" and marks the given dates (from "K") in the Timeline in "Sheet1".

And are you in the position to make the timeline grey(light) and mark events red?

Thank you

**Julian Schubert** · 06-22-2011, 07:25 AM

@snb:

what do you mean by

the debugging tool in the VBEditor

?

If it is what I think it is... I tried but I did not manage to solve my problems in the code...

Thank you

**watersev** · 06-22-2011, 08:08 AM

@ Julian Schubert, what should happen if August 4, 2011 is selected? We need to colour 04.08.2011 and till the NB4 on Sheet("Sheet1")?

**Julian Schubert** · 06-22-2011, 08:15 AM

Thank you waterserv.
Unfortunately an error occurs:

Run-time error "13"
Type missmatch

and this line gets marked yellow

Please Login or Register  to view this content.

**romperstomper** · 06-22-2011, 08:30 AM

Try replacing:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

**snb** · 06-22-2011, 08:32 AM

Debugging: use F8

DateDiff("d", Cdate("01.01.2011"), Target)

**Julian Schubert** · 06-22-2011, 08:51 AM

still not working

put in this code now

Please Login or Register  to view this content.

does not work....

same error occuring... missmtach... run-time error...

have you tried out the code in my file?

**watersev** · 06-22-2011, 09:07 AM

you misplaced coma and round bracket after offset, it should be:

Please Login or Register  to view this content.

**Julian Schubert** · 06-22-2011, 09:13 AM

okay now it is working - but the whole timeline is red know...

I do not see any changes :-)

It would be wonderful if just the exactly event in the timeline is red... and the line grey...

**watersev** · 06-22-2011, 09:21 AM

colour the timeline in grey, and try again

**Julian Schubert** · 06-22-2011, 09:33 AM

I already did, but it gets red every time again... do not worry I am working with you

I just saw that there is a code in "Sheet1", is that influencing the whole process?

Code "Sheet1"

Please Login or Register  to view this content.

**Julian Schubert** · 06-22-2011, 09:33 AM

Thank you in advance.

**watersev** · 06-22-2011, 09:53 AM

Originally Posted by Julian Schubert

I just saw that there is a code in "Sheet1", is that influencing the whole process?

Yes, it colours the whole row

Please check attachment, I'm using Excel 2003 so I do not have so many columns as you do, but you'll be able to see how it works. Change date 10.03.2011 to say 10.02.2011

**Julian Schubert** · 06-28-2011, 03:21 AM

sorry for the late answer - other projects...

so now my situatuion is that I am not smarter than before because I do not understand your attachement or at least how I can benefit of it

So now my timeline works, but it still marks the whole row and I would be happy if only the date in Row 'K' (for ex 22/08/2011) gets marked on the timeline.

And it only shows the first entry in row "K" in the timeline and not the following.

Furthermore, the timeline is still completely red and I would be happy if the timeline is grey and the selected dates are marked red.

In addition, is it possible that I have 3 timelines (4 years (2010/2011/2012/2013)) each under the other... ?
... I want to solve the problem that I have dates of different years in row K...

Find attached again the file.
Can you change it the way I want to have it?.

Thank you very much in advance.

Julian

**watersev** · 06-28-2011, 08:31 AM

please check attachment, insert dates in K3:K5 on Sheet2 and check result on Sheet1, the code is in Sheet2 module. It's done only for 2011

**Julian Schubert** · 07-06-2011, 07:21 AM

Hello waterserv,

Thank you for your file!

Unfortunately, it does not work - If I insert dates in K3:K5 on Sheet1 an error occurs:

Run-Time error '13'
Type missmatch

Can you help me again pls?

Thank you.

**watersev** · 07-06-2011, 08:30 AM

hi, Julian, the dates are entered on Sheet2, everything works as it should, check attachment for result of three dates entered

**Julian Schubert** · 07-06-2011, 09:23 AM

Hello waterserv,

Thank you again.

I do not why but it does not work for me... Even when I just try to change a date you have already entered.

He gives me the same 'runtime error' and marks

this row

Please Login or Register  to view this content.

yellow...

Dou you know the solution?
Do you use Excel 2007?

Thank you for your support.

Belonging Row is not clear in Code

LinkBack

Thread Tools

Rate This Thread

Display

Belonging Row is not clear in Code

Re: Adopt Code

Re: Adopt Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Re: Belonging Row is not clear in Code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions