ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Execute VB Form from Excel (https://www.excelbanter.com/excel-programming/300068-re-execute-vbulletin-form-excel.html)

Ed[_18_]

Execute VB Form from Excel
 
Do you mean a UserForm created in Excel VBA? Or do you mean a Form in an
external Visual Basic 5.0/6.0 application? When you say "from Excel", what
do you mean - when you enter a value, when you open or close the workbook,
when you call a macro while working in a workbook, or ???

"plains5728" wrote in message
...
How do I execute a VB Form from Excel? I can execute from the VB Editor

but I want to run execute the form from Excel.



kkknie[_119_]

Execute VB Form from Excel
 
If you want to do it from a comandbutton, just use:

Private Sub Command1_Click()

UserForm1.Show

End Su

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com