How Can I embed a Form into a worksheet

[John Hughes]

Hi all
Any one know how I can embed a form into a worksheet. The one I created
floats over the sheets and looks quite untidy. If also does not allow
swapping between tasks until it is hidden. Any help would be much
appreciated

 

[Tom Ogilvy]

the controls you use on your userform can be placed on the worksheet
themselves - however the userform can't. You can just rebuild the
functionality on the worksheet using the Control Toolbox Toolbar controls.

 

[John Hughes]

Thanks Tom. I was afraid of that. Why I asked is that a couiple of years ago
I seem to remember that it was possible to insert a new worksheet of type
"form". I take it this is no longer the case ?

 

[Tom Ogilvy]

You can insert a worksheet of type dialogsheet, same as you could a couple
of years ago - but when you run it, it appears as a dialog similar to a
userform.

Right click on the sheet tab and select Insert and then select dialog sheet.
The controls for the dialog sheet are from the forms toolbar.