Details for edgarfreitas

edgarfreitas has participated in the following threads:

Added by edgarfreitas on 04 May 2017 at 18:18

Hello,

I'm having troubles in achieving something on excel and I think you are the right guy's to give me a hand with it.

I have an excel sheet that I use for flight simulation and between other things, I want to create a small compus with shapes(arrows) that rotates whenever I add a value to a specific cell. So far I managed to do it but only with a single arrow. When I try to add a second shape it says "Ambiguous name detected worksheet_Change".

I need 2 arrows because one indicates the heading of the aircraft and another indicates the wind.

On VBA I managed to do the following:

Private Sub Worksheet_Change(ByVal Target As Range)
'event raised when value in cell changed BY USER

Dim KeyCells As Range
Set KeyCells = Range("Z2")
If Not Application.Intersect(KeyCells, Range(Target.Address)) Is Nothing Then
MoveArrowToA1
End If
End Sub
Sub MoveArrowToA1()
'Select shape to move
Dim CellValue As Integer
Dim CurrentlySelected As Range

Set CurrentlySelected = Selection

CellValue = Sheets("747 lbs").Range("Z2")
ActiveSheet.Shapes.Range(Array("seta")).Select
Selection.ShapeRange.Rotation = CellValue + 180 'Plus 180 since 0 pos is down

'Select prev cell that was in use
CurrentlySelected.Select

End Sub

This gives me only the rotation for one of the arrows (shapes), do you have any idea how do I add a second one?

https://drive.google.com/file/d/0B6JMHUkV2NKJRTZVUmRBZER6bVE/view?usp=sharing On this link there's a picture to give you the idea of what I'm trying to do.

If you need any other information from me, please let me know.

Thank you very much for all the help you can give me.

Kindly,

Edgar Freitas

View relevant page

Added by edgarfreitas on 26 Sep 2016 at 11:33

I just read this article about "Getting Excel vba speak to you". My question is if you could help me setting up my excel sheet to speak a few selected cells when I press the "calculate" button. Is this possible to do with excel? I have about 8 cells that gives me some calculation results that I would like to be read when I press the calculate button.

View relevant page