i want to try and get a better understanding of VBA, i don't understand public, private, global etc...
where i should put what and where...
what i can use what i can't use....
error handling etc..
is there a good website, book or refernce point that explains from scratch how to use and write VBA please
cheers
Andy
I have a Text box on a Form that copies data entered into other Text boxes on the same form.
I have used the formula =[Text2] &" "& [Combo26] etc in the main text box that I want all the information in.
Sometimes there may be the odd text box that does not have any data in it.
Is there anyway that I can put in code so that the blank text boxes are not copied into the main text box i.e. Only the populated text boxes are to be copied.
Thankyou for any assistance that you can provide.