Need Keyboard Shortcuts with FORMS
Does anyone have a way to use keyboard shortcuts to change the color of a field?
I am trying to write a VBA code, that takes a status from Excel, and then exports that to a visual color in to the pdf. I can't use a mouse action because it is coming from a MACRO.
Is there a different way to do something like this? Maybe change the color of the font? I am trying to think of many ways to figure this out and I'm drawing a blank.
So, here is what I need to do...
Complete an Excel spreadsheet that contains all pertainent data and a RAG (red, amber, green) status field
Map the data from the excel spreadsheet to the corresponding fields in the pdf Form
When I need to map the RAG status of the project -- (this is where I'm stuck) -- how to I tell the pdf to color code a particular text box, radio button, etc to FILL IN the object with a corresponding color from the excel file?
I am open to all and any suggestions.
Here is the issue, in order for the VBA script to work, coloring filling the object in the PDF must be done through keyboard actions.
Thank you so much for any help or insight you can give me.
