How do i test if a form (not MsgBox) button is clicked?

**Platempole** · 01-20-2022, 02:41 PM

Hello,
I have an Excel form that displays records from an external file. The form has these buttons to traverse the records:

[<<] , [ < ] , [ > ] , [>>] (viz. btnFirst, btnPrevious, btnNext, btnLast)

The buttons are not assigned to macros; instead they are part of the VBA code (below). How do I properly check for a button press?

Thank you.

Please Login or Register  to view this content.

**GWteB** · 01-20-2022, 06:02 PM

Hi Platempole, welcome to ExcelForum!

Excel is event driven. The click events of commandbuttons on a userform are exposed so you can use them without the need of assigning macros to your buttons. Using a loop isn't needed either.

**torachan** · 01-20-2022, 06:19 PM

@Platempole, see big yellow banner - upload your actual workbook - then we can give you a context related solution.

**Norie** · 01-20-2022, 06:42 PM

If you double click on any of the buttons when in design view you should then see a code stub like this.

Please Login or Register  to view this content.

This is where the code for the click event for a button, in this case btnFirst, should go.

Note - do not use names for variables that are the same as controls on the form.

**Platempole** · 01-20-2022, 11:03 PM

Appreciate all your responses. Norie, thanks for your input; working on it...

**Artik** · 01-20-2022, 11:37 PM

You can also use the ActiveControl property of the UserForm object. E.g:

Please Login or Register  to view this content.

Artik

**torachan** · 01-21-2022, 05:12 AM

If the form has numerous buttons you could set up a 'Button Class module' to test which is 'clicked' (saves individual code for each button if actions are common in nature).
Two files attached, one simple one demonstrating the actions just identifying the buttons pressed, the other shows the usage in my calendar intercepting the 42 day buttons (double click in column 'A' or 'B' for pop-up calendar).