• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

Draw line on user form in excel

Can I draw a line on a user form
in Excel?
0
mdanny
Asked:
mdanny
1 Solution
 
mayhewCommented:
I don't understand the SQL in this question, but if I understand what you're asking...

You can draw a line in Excel using a macro or in VB using something like the following:

ActiveSheet.Shapes.AddLine(28.5, 15.75, 28.5, 180.75).Select


The first two numbers are the x and y coordinates of the start of the line.

The last two numbers are the x and y of the end of the line.

The example I gave is a vertical line (notice the x values for the begin and end are the same).

Let me know if this answers your question.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now