Ok, so i got it put into a little macro window with a text field for the answer, but it is creating copies of whatever text is selected.
For example i typed 12, then 3, then 2 as seperate items. i selected them all and ran the macro. when i hit the calculate button it gives me just the first item in the series (i have it set to show d after the IF statement finishes), but it also copies it in the drawing! So if i have just 12 selected it will act like i selected the 12, hit enter and typed 12 again.
If i use them as the same item (12 3 2) i get the answer 17 in the d field, but it also changes the text to 17 and adds another line of 17 underneath that. haha.
any help?
EDIT: Fixed - just got rid of the tr.Text = d & vbNewLine line. Now i just have to make it work on a selection of icons with the text as part of the group haha. Any help appreciated.