search

byronwall / bUTL

Excel add-in with helpers for charting, formatting, and general pain points
http://byroni.us/bUTL
MIT License
16 stars 3 forks source link

Change Chart_GetObjectsFromObject to use TypeOf instead of TypeName #35

Closed byronwall closed 8 years ago

byronwall commented 9 years ago

TypeOf is a more robust way to check if an object is of a certain type. This should provide a better way of working through the Selection and determining what type of object is involved.

byronwall commented 8 years ago

The bulk of this issue is resolved. There is still a problem where selecting a Chart Axis does not allow you to determine the Chart that was selected. This appears to be a known issue since the Parent on the Axis is not the Chart but is instead the Worksheet. Not helpful. Might try to find a workaround for this. For now, there is a specific prompt about axes not working.