excelvba

Put a user form directly on the excel sheet


Is there any way to insert a user form directly on the excel sheet?

We can add the build-in controls as well as active x controls. I don't see why we cannot add user forms within the same workbook.

Thanks


Solution

  • No, I don't think it's possible.

    Userforms are merely containers to hold your ActiveX controls. Spreadsheets are also ActiveX control containers, so I'm not sure what the benefit of having a container in a container would be.

    You could easily color a group of cells to look like a userform and place ActiveX controls within that range. That would simulate a userform embedded on a spreadsheet. You'd be missing userform level events and probably a few other things. But if you wanted those things, you'd probably just use a userform.

    If there's something you want to do that I'm missing, let me know.