customised userform
 

Hi, I have a dialogbox (Set shp1 =
ActiveWorkbook.ActiveSheet.Shapes.AddShape(msoShap eRectangularCallout, 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.

customised userform
 

All most anything you do via VBA code (from a code module, object
module, or userform) clears out the Undo buffer. You could try to
write your own Undo method, but that can get rather tricky rather
quickly.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 16 Mar 2009 05:08:01 -0700, filo666
wrote:

Hi, I have a dialogbox (Set shp1 =
ActiveWorkbook.ActiveSheet.Shapes.AddShape(msoSha peRectangularCallout, 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.