Check Boxes

[Guest]

Hi,

I wrote a 2 macros and these run when you click on check box A or B.

One does a calculation with inflation and another without inflation.

I wanted to put the checkboxes on a form. But I want the form to be
permanently embedded on the sheet, because I think it would look nicer. I
tried putting the checkboxes on a "image" from the control toolbox, but this
didn't work.

Do you have any suggestions?

Thanks

 

[Guest]

Not really clear what you want: The "look and feel" of a separate
form/dialog box, but "pinned" to a worksheet?

Two approaches:
1) Create a userform, then link it to the SheetActivate & SheetDeactivate
events to always show it when the desired sheet is active and hide it if it
is not active.

2) "fake" a form on the worksheet. The idea of using an OLE image box
should work, I would think - take a screenshot of a form background, crop it,
and insert it onto your sheet. Or, use drawing objects to make a form
lookalike. With shadow and 3D options, you can make a rectangle look pretty
much like a form or dialog box.

But there are a lot of formatting options that you could use to make an
attractive user interface. Not sure creating a "form" of these is the way I
would go, but to each his or her own.