ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding a control to a User Form (https://www.excelbanter.com/excel-programming/343049-adding-control-user-form.html)

scantor145[_22_]

Adding a control to a User Form
 

Can anyone tell me why, on some occasions, that after I add a control to
a User Form, e.g. a checkbox whose name is chkTest, and then go to View
Code, the following code which should appear, does not?


Code:
--------------------
Private Sub chkTest_Click()

End Sub
--------------------


No matter what I do, it never shows up.


--
scantor145
------------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=476923


Tom Ogilvy

Adding a control to a User Form
 
I haven't had that problem if I double click on the check box in the VBE.
Anyway, it is easy enough to get it. In the dropdowns at the top of the
Userform Module, in the left dropdown select chkTest and in the right
dropdown select Click (if it hasn't already put in the declaration).

--
Regards,
Tom Ogilvy





All times are GMT +1. The time now is 06:25 AM.

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