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
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.