556 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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
'Select shape to move
Dim CellValue As Integer
Dim CurrentlySelected As Range
Set CurrentlySelected = Selection
CellValue = Sheets("747 lbs").Range("Z2")
Selection.ShapeRange.Rotation = CellValue + 180 'Plus 180 since 0 pos is down
'Select prev cell that was in use
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.
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.
25 Aytoun Street