Programming Dropdown Box to allow certain selections to change fonts

**mykie** · 07-31-2012, 10:20 PM

Hi Guys,

I am hoping that this can be done.

I have a bunch of word dropdown boxes and I need to change the color of certain words based on what the user has selected. For instance if the user chooses the word "vacant" then highlight the selected word red. I also need it to work so that if any other words are selected the word is kept in black.

Hope someone can help.

Regards,
Mykie

This is what I have attempted:

Please Login or Register  to view this content.

**macropod** · 07-31-2012, 10:28 PM

Hi Mykie,

Your macro works fine, so I don't see what the issue is.

PS: When posting code, please use the code tags.

**mykie** · 07-31-2012, 11:54 PM

Thanks for the reply.

yes, the macro seems to work fine however when I protect the document and select "vacant" from the list whether I remain in the field or exit it the word remains black. I ensure that macro works on exit however it doesnt seem to operate as I wanted it too?

cheers,
Mykie

**macropod** · 08-01-2012, 01:10 AM

As it's an 'On Exit' macro, you must exit the formfield (eg by pressing the Tab key) to trigger it.

**mykie** · 08-01-2012, 01:18 AM

Originally Posted by macropod

As it's an 'On Exit' macro, you must exit the formfield (eg by pressing the Tab key) to trigger it.

Hey Macro,

cheers for the response again.

I understand what you are saying but I kept getting a "Run-Time Error 4605: This Command Is Not Available" When You Use PageSetup Property" message which was causing me grief. I ended up just closing the document and reopening it which seem to have it working again. Not sure what the issue was but I got it working now.

Cheers,
Mykie

**macropod** · 08-01-2012, 09:14 AM

Hi Mykie,

I don't understand why you'd get such an error - there's no page setup code involved.

**mykie** · 08-01-2012, 06:53 PM

Hi Macro,

I can't elaborate any further, sorry.

I am not sure why the error occured but it seems to have gone away now with a new reopened document.

Regards,
Mykie