Geek asks and answers

Place custom form directly on excel sheet

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

We can add inline controls as well as active x controls. I do not understand why we cannot add custom forms to the same workbook.

thank

+3
source share
3 answers

No, I do not think this is possible.

Custom forms are just containers for storing ActiveX controls. Tables are also ActiveX management containers, so I'm not sure it might be useful to have a container in the container.

, ActiveX . , . , , . , .

-, , , .

+2

WorkSheet VB:

Sub Worksheet_Activate()   UserForm1.Show End Sub

+1

MyForm.Show Workbook.Open, , ... . , .

Your desire, if possible (I'm sure this is not so), can trigger a simultaneous VB code: for example. automatic cell calculation and form code. This is a problem because XL is the only VBA thread, so it is impossible to have two things. Either the form or the code is displayed, or the XL application is running, as well as the cell / graphs / etc elements.

0
source

More articles:


All Articles