Forum Discussion
Solved
Use Form to update data
When the command button New Record is clicked the user enters a value into a Form which will then be entered into F7 (or the next available empty cell in F) When the user clicks OK E7 is then updat...
Your command button is a Form Control, not an ActiveX Control, so the macro should be in a standard module, and it should not be private.
Also, delete the instructions in F19:F23, or move them to another column.
See the attached version.
Your command button is a Form Control, not an ActiveX Control, so the macro should be in a standard module, and it should not be private.
Also, delete the instructions in F19:F23, or move them to another column.
See https://vemapostar-gift-pt.com/ the attached version .
Why do macros for ActiveX buttons work differently? Is there a difference in their performance or compatibility?
- To assign an action to a Form Control, create an ordinary macro in a standard module.
- To assign an action to an ActiveX Control, turn on Design Mode and double-click the control.
This will open the worksheet module and create a so-called event procedure. - Form Controls work on Windows and Mac, while ActiveX Controls work only on Windows.