Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
how do i code a button click (a vb form button)
I'm using Sheets("Stats").CommandButton2_Click This produces the error: object doesn't support property or method. HELP! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The command button click procedure has to be declared as Public not Private
(Sorry I just got around to answering your last post... Meetings.). Public Sub CommandButton2_Click() 'do your button click stuff End sub -- HTH... Jim Thomlinson " wrote: how do i code a button click (a vb form button) I'm using Sheets("Stats").CommandButton2_Click This produces the error: object doesn't support property or method. HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
generate column of 360,000 RAND()s without the click and drag | Excel Discussion (Misc queries) | |||
Create floating button based on button click in menu | Excel Programming | |||
Button to generate report | Excel Programming | |||
VBA button click need help. Need LEN help. | Excel Programming | |||
VBA button click need help. Need LEN help. | Excel Programming |