Drawing circles in excel from a form :((
-
I have a class which keeps track of a few circles and draws them in a row using Worksheet.Shapes.AddShape I was quite happily calling member functions and running them from a module with no problems. Then I tried to implement a form to take input (how many circles, size, position etc) and pass it to the class and have it drawn. I just used a handful of TextBox controls. A button is used to copy all the textbox values when pressed, and pass each to the class. Everything worked as before, except that the first circle in the row will never be drawn. The other circles will be drawn in exactly the right position as if there had been a first circle, but instead there is a blank space. I have isolated the variable which is passed to the class which causes the problem - it is the x position on the sheet. I have used the locals window to check what value is passed to .AddShape and it is exactly the right value of 400. Yet the circle never appears. Change the button function to call 400 instead of taking the same value from the form, and it is back again. I have tried passing the variable by value which I would have thought would make the two cases indistinguisable to .AddShape. No luck. I have checked pretty thoroughly that the circle is not just being drawn in the wrong place or somewhere else. So I give up. Any suggestions would be greatly appreciated, even/especially the general debugging approach you might use for something like this (bear in mind I am a certified newbie....) Thanks