Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
user form & control properties | Excel Programming | |||
user form and frame control | Excel Programming | |||
Spreadsheet Control on User Form | Excel Programming | |||
help: master control macro and user form | Excel Programming | |||
Control Order on User Form | Excel Programming |