Who_else
03-31-2016, 06:29 PM
Hello there!
I'm very new to the word VBA scene, have done a bit of Frankenstein work with Excel's VBA and have built some handy things,
I cannot seem to think of a way to reference a content aware section, Usually I just record macro, do what I need, and steal that bit and tailor it for a bigger macro project, but when I record and select the content aware text, it records nothing in VBA.... So I'm at a loss.
What I am needing to do is as follows:
I have a leave request document that is used by the whole office,
in that I want all of the sections to be able to be sections to fill that are then checked by a macro (when a submit button is clicked) that will check their surname and save it in their personal file, as well as check their position (from a drop down list) and email it to their direct team leader.
any help is greatly appreciated.
Thanks in advance.
I'm very new to the word VBA scene, have done a bit of Frankenstein work with Excel's VBA and have built some handy things,
I cannot seem to think of a way to reference a content aware section, Usually I just record macro, do what I need, and steal that bit and tailor it for a bigger macro project, but when I record and select the content aware text, it records nothing in VBA.... So I'm at a loss.
What I am needing to do is as follows:
I have a leave request document that is used by the whole office,
in that I want all of the sections to be able to be sections to fill that are then checked by a macro (when a submit button is clicked) that will check their surname and save it in their personal file, as well as check their position (from a drop down list) and email it to their direct team leader.
any help is greatly appreciated.
Thanks in advance.