已取消

Excel VBA cell to shape

Platform: Windows XP, Vista or Win7.

Deliverable:

1.? ? ? ? ? ? Excel 2007 VBA for saving in any [url removed, login to view] macro enabled workbook.

2.? ? ? ? ? ? VBA code should contain full English comments explaining the work performed in each section of code.

3.? ? ? ? ? ? All deliverables will be considered “work made for hire?? under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder’s Seller Legal Agreement).

## Deliverables

1. Given a certain range of contiguous cells in Sheet1, for each cell in that range that contains any numeric or text value (is not empty), draw a Rounded Rectangle in another Sheet2.? The contiguous range of cells should be selectable and specified in the heading of the VBA code, like ‘Sheet1!A5:A99’. This VBA macro will only apply to that range of cells.

2. Each Rounded Rectangle should initially be drawn starting in cell A1 of Sheet2.?

3. The text label of each Rounded Rectangle in Sheet2 should contain the value of its corresponding cell in Sheet1.

4. Each Rounded Rectangle can have a row height that is somewhat greater than the standard Excel row height of 15, in order to show the text label correctly. The dimensions of the Rounded Rectangles in Sheet2 should be selectable and specified in the heading of the VBA code and applies to all the Rounded Rectangles drawn by this macro in Sheet2.

5. The fill color and border color, style and thickness of the Rounded Rectangle should be easily selectable and applies to all the Rounded Rectangle shapes drawn by this macro. This selection should take place in the heading of the VBA code.

6. Behavior: When the value in the ‘parent’ cell in Sheet1 changes, the text label in the corresponding Rounded Rectangle in Sheet2 should automatically change.

7. Behavior:? When any new values are add to cells in Sheet1 they will ALWAYS be added at the END , after the LAST cell that contains a value.? In other words if the Sheet1 selectable? range is A5:A99 and cells A5:A25 contain values, you can assume any new values will be placed in cells starting with A26. The VBA should insert a new Rounded Rectangle in its corresponding cell position in Sheet2.

8. Behavior: When a cell or range of cells is deleted from Sheet 1, the corresponding Rounded Rectangle(s) does NOT need to be deleted from Sheet2. However, the text in the Rounded Rectangle should show a standard Excel REF error.

技能: 工程, Excel, 微软Access, 微软Exchange, MySQL, PHP, Powerpoint, 软件构架, 软件测试, Visual Basic的应用程式, Word

查看更多: excel vba cell position, excel shape, excel vba cell, excel shape border style vba, excel vba shapes rounded rectangle label, vba shapes cell, vba work, vba with, vba coder for hire, row 44, hire dimensions, hire a vba coder, excel for windows 8, cell hire, cell for hire, vba for, vba error, excel vba with, excel vba or, excel vba and

关于此雇主:
( 2个评论 ) Tempe, United States

项目ID: #3182906

11 威客就此工作平均出价 $34

Schura

See private message.

$21.25 USD 在14天内
(56条评论)
5.4
bfpickford

See private message.

$42.5 USD 在14天内
(55条评论)
5.3
sarmadmakhdoom

See private message.

$29.75 USD 在14天内
(85条评论)
4.7
juan1matos

See private message.

$38.25 USD 在14天内
(24条评论)
4.2
manojyohannan

See private message.

$42.5 USD 在14天内
(31条评论)
3.9
getitrightvw

See private message.

$42.5 USD 在14天内
(31条评论)
3.9
rafaelg

See private message.

$25.5 USD 在14天内
(14条评论)
3.8
exactcomplete

See private message.

$42.5 USD 在14天内
(2条评论)
1.3
amirshahzad83

See private message.

$21.25 USD 在14天内
(0条评论)
0.0
mmonem

See private message.

$42.5 USD 在14天内
(0条评论)
0.0
madushankaf

See private message.

$21.25 USD 在14天内
(0条评论)
0.0