F
filo666
Hi, I have a dialogbox (Set shp1 =
ActiveWorkbook.ActiveSheet.Shapes.AddShape(msoShapeRectangularCallout, lft +
wth - 9, tp - 5.9 * hgt, 110, 65))
that is called in a selectionchange event, the problem is that when it is
called the undo is lost, I dont want to lose the undo, therefore I thought
about using a Userform (modeless), the problem with the userform is the form
(I wanted to be like msoShapeRectangularCallout) and the background color (I
want yellow with 40% transparency and no border lines)
the rest of the thinks I know how to accomplish (possition, etc).
any suggestion will be appresiated.
ActiveWorkbook.ActiveSheet.Shapes.AddShape(msoShapeRectangularCallout, lft +
wth - 9, tp - 5.9 * hgt, 110, 65))
that is called in a selectionchange event, the problem is that when it is
called the undo is lost, I dont want to lose the undo, therefore I thought
about using a Userform (modeless), the problem with the userform is the form
(I wanted to be like msoShapeRectangularCallout) and the background color (I
want yellow with 40% transparency and no border lines)
the rest of the thinks I know how to accomplish (possition, etc).
any suggestion will be appresiated.