This is a 2 part question and hopefully I can get help on it. I want to be able to change the background and font color in my rollong text box with a macros or a VBA code. The color schemes would be Red background with bold white lettering for one of them and a yellow background with bolded dark blue lettering as the other. I am using an Active X text box for this.
The second part of the question is I would like to be able to use a macro to create a PDF copy of the text data or be able to copy the data and then paste it to word or possibly OneNote. Can these be created? I tried to highlight some previous info in my text box but the copy function and background/font colors were grayed out.
Thanks
The second part of the question is I would like to be able to use a macro to create a PDF copy of the text data or be able to copy the data and then paste it to word or possibly OneNote. Can these be created? I tried to highlight some previous info in my text box but the copy function and background/font colors were grayed out.
Thanks
