Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to show the position of shapes like "rectangle"
hi, anyone help me pls.
I try to create a simple game for leader by using excel. I create ten rectangle boxes. And individual moving box in each time I need to check the position of the rectangle box which is wrong or correct? Here is my code : Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("a1").Value = Shapes("rectangle 1").Left Range("b1").Value = Shapes("rectangle 1").Top End Sub if I use that code I have to click on the sheet except the rectangle box so that it will show the position of the rectangle box. But what I need is when I move the rectangle by using mouse up I want cell(a1) and cell(b1) show the position of rectangle automatically. Some one give me the solution pls. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
how to show the rectangle box position | New Users to Excel | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions |