Does anyone know of a publication that provides readily explained samples of code that would benefit those non-programmers / software developers amongst us and that helps to understand Excel VBA and some of the most frequently used and / or required actions.
I have a number of reference books , some for beginners others are more in-depth, but I can never seem to be able to find the simple solutions to requirements.
I have spent hours trying to resolve simple issues such as formatting a textbox into Currency, automatically running macros / modules when a User Form is opened and trying to copy data into a large number of cells without having to create a separate line of code for each textbox. Unless you are fluent in VBA then trying to find a solution is a minefield. (I have a solution for calling from an Array of Columns and a range of rows, but this code cannot be readily adapted where the information for each IF condition where the matching to consecutively named TextBoxes need to be applied by rows and not columns, as the syntax and code is different but finding the correct information is almost impossible for us novices
Many thanks
I have a number of reference books , some for beginners others are more in-depth, but I can never seem to be able to find the simple solutions to requirements.
I have spent hours trying to resolve simple issues such as formatting a textbox into Currency, automatically running macros / modules when a User Form is opened and trying to copy data into a large number of cells without having to create a separate line of code for each textbox. Unless you are fluent in VBA then trying to find a solution is a minefield. (I have a solution for calling from an Array of Columns and a range of rows, but this code cannot be readily adapted where the information for each IF condition where the matching to consecutively named TextBoxes need to be applied by rows and not columns, as the syntax and code is different but finding the correct information is almost impossible for us novices
Many thanks