How to DRAW a line in VBA

Attachment 302856Hi everyone,

Can somebody help me with my problem.
I'm trying to make a timeline which moves depending on which week it is. So I define the week number in a cell, search for the the value of this week and get to the cell from where to start drawing a line by using that code:

Please Login or Register  to view this content.

From here I found a code that can Draw a line through the center of the cells:

Please Login or Register  to view this content.

My question is how to combine these macros so the line will be drawn depending on the week number. I mean so this line can change values:

Please Login or Register  to view this content.

And the second question, how to change color of the line to red? I've tried with this one but with no luck:
'.ForeColor.RGB = RGB(255, 0, 0) ' red

I've tried in different ways for 2 days now without luck.


I hope somebody can help!

Thanks in advance!

Michael

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


Does the cell you search for contain "C1" or "C10". Or is the position of the cell to be used instead of either "C1" or "C10"?

Does the line move or just get longer? Perhaps an example file would help explain your problem

Thanks for fixing code tags.

Did you attach example file?

Okay so you need to explain, for you file, where should the line be drawn. Where does it start, where does it finish?

You have a date in A1 but no other real dates.

Please Login or Register  to view this content.

Hi, I saw this old topic and the code. I did search for a similar problem and came here.
I have one question about the code

Please Login or Register  to view this content.

this gives me a error in excel 2019. What is it doing?

Thank you

I did start a new thread about this topic here.