how to assign events to controls on [ Microsoft Forms 2.0 Frame ]

S

smallxyz

Active Member
Joined
Jul 27, 2015
Messages
392
Office Version
  1. 2021
Platform
  1. Windows
On a worksheet, I have created a MS Forms 2.0 Frame and added several commandbuttons onto it.
But how can I code some events into the commandbuttons?
I can't locate their names and appearance in VBE and elsewhere.

The reason of using Frame is to fix the positions of a bunch of already-made event-enabled commandbuttons on a worksheet.


Thanks a lot!
 
Last edited:

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
Hello,

In terms of flexibility ... you would be much better off ... with ActiveX controls ...

HTH
 
Upvote 0
Ya. All my commandbuttons are of ActiveX types. Just not sure how to bound them together within an area.
Oftentimes, these buttons just mess around from the original positions for unknown reasons.
I try to group them, but the event code seems then to be no longer available.
 
Upvote 0
Hello again,

If you change the Placement value to 1 ... your problems are over ...

HTH
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
399
AndyEd
A
M
  • Question
Need to add _AfterUpdate events to a dynamically-created class
Replies
1
Views
893
Matrovsky
M
A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A
L
  • Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13
P
  • Question
How to tab to a specific control automatically once an option button inside a frame is selected
2
Replies
12
Views
2K
mumps
mumps

Forum statistics

Threads
1,215,022
Messages
6,122,721
Members
449,093
Latest member
Mnur

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top