+ Reply to Thread
Results 1 to 1 of 1

Macro that would draw a line using cell borders after user input

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    New Bern North Carolina USA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Macro that would draw a line using cell borders after user input

    I have been trying to make a small drawing application in Excel 2010 using macros. To be more specific, I would like the user to be able to enter a line dimension, select a starting point within a predefined area, click on a direction arrow (a shape, showing north, south, east, or west) and draw a line (using a cell border) in the specified direction. After the line is drawn, a text box with the user entered dimension will be placed within the predefined drawing area. I have had limited success using predefined lengths and directions, but it is very cumbersome. Is there a way to make the user inputted length a variable "X" that will draw the cell outline "X" number of boxes north, south, east or west? Could you then replace the text in the dimension text box with that same variable? I have attached a pick of what the spreadsheet would look like. Any help would be appreciated.
    Attached Images Attached Images

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Macro that would draw a line using cell borders after user input

    Check out the two examples to get you some ideas.

    http://www.davesexcel.com/excelexamples.htm#927029066
    http://www.davesexcel.com/Calculate%...n%20chart.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data Input Form with number of line items based on user input
    By j_gideon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2013, 02:54 PM
  2. [SOLVED] Macro that can draw borders in cells with data across multiple sheets in a workbook
    By kodos10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2013, 08:01 AM
  3. UDF to set borders or draw line in current cell
    By DJWim in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-26-2012, 07:42 PM
  4. Macro to draw a Line Graph
    By jmadsen in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 10-16-2012, 01:18 PM
  5. Using a macro to draw borders
    By Jen5309 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2008, 02:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1