Hi community
I am still a beginner with VBA and my goal is to have a dropdown that sets the text and color of the respective cell in a table:
- The user selects the red "level" and the requirements are populated based on it (low/med/high)
- Ideally, the cells or background of the low/med/high are also color-coded (this is where I struggle)
- See the screenshot for visualization
I managed to get the low/med/high texts updated based on the level input through
CustomXMLNode, but I am currently still struggling with the coloring. The coloring seems inaccessible through the XMLNode...any ideas and also feedback on the code are greatly appreciated, thx!
PS: I am using
BeforeStoreUpdate instead of
OnExit because I want to have it more interactive/quicker given that there is no
OnChange Event.
PPS: I am using
content controls over form fields because a) more modern and b) more responsive at the cost of having to use macros. Do you agree with that?
PPPS: Linking to
this for awareness.