- Combo box : control souce -unique column, but set first column to the column you want to show(Other Column)
- Other column: set hide control and set the value when combo box change
Monthly Archives:: May 2021
Benefit for learning VBA
Unlike macros, VBA enables you to do the following:
- Work with complex logic structures (case statements, loops, and so on)
- Take advantage of functions and actions not available in macros
- Loop through and perform actions on recordsets
- Perform transaction processing