News

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.
Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...
ComboBox.BoundColumn Property (Access) When you make a selection from a combo box, the BoundColumn property tells Microsoft Access which column's values to use as the value of the control. If the ...
Build Your Skills: Create connection-sensitive combo boxes in Access Your email has been sent You may be a whiz at writing single-user Access database applications, but you’ll probably find that ...
Custom Tickbox Class: The clsTickBox class module allows you to create customizable tickboxes within Excel cells. Easy Integration: The modTickBox module provides simple subroutines to handle the ...
To create a custom function in Excel VBA, you need to enable the Developer tab and go to the Visual Basic panel. Next, right-click on Microsoft Excel Objects > Insert > Module and enter the code.
Right now it only works in a formular but i really need to be a function with input / output in a module so i can call it from the whole project.