Hello All,
Would really appreciate some assistance on this one. My speedometer dial will only rotate when I manually enter the value in cell D5 on the worksheet. I am looking for the value to be pulled from another cell in another worksheet rather than D5 on the current sheet. How can I adapt the code? When I pull the value into D5 from another sheet it wont rotate the dial.
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Shapes.Range(Array("Group 17")).Select
Selection.ShapeRange.Rotation = Range("D5").Value * 249
ActiveCell.Select
End Sub
Would really appreciate some assistance on this one. My speedometer dial will only rotate when I manually enter the value in cell D5 on the worksheet. I am looking for the value to be pulled from another cell in another worksheet rather than D5 on the current sheet. How can I adapt the code? When I pull the value into D5 from another sheet it wont rotate the dial.
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Shapes.Range(Array("Group 17")).Select
Selection.ShapeRange.Rotation = Range("D5").Value * 249
ActiveCell.Select
End Sub