Change color according with dropdown selection

spk · #1 04-04-2013, 12:21 PM

Thanks for your help macropod!

But unfortunately I get the same error, so I think the problem is not the code, but the way it's linked to my dropdown.

Does "ColorPicker" should be the title of the dropdown, or its tag, or the name of a bookmark?...

macropod · #2 04-04-2013, 02:16 PM

Quote:

Originally Posted by spk

But unfortunately I get the same error, so I think the problem is not the code, but the way it's linked to my dropdown.

Does "ColorPicker" should be the title of the dropdown, or its tag, or the name of a bookmark?...

"ColorPicker" is the name of the formfield's bookmark. You set it via the formfield's properties.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
block selection in dropdown list	Intruder	Excel	2	01-10-2013 10:20 AM
Dropdown selection value	coconutt	Word VBA	5	09-13-2012 05:23 PM
Change cell color when selection is made from a drop down list	fedcco	Excel	12	08-28-2012 10:43 PM
Autofill a form which is contingent on a dropdown selection.	biffle0764	Word	2	05-09-2012 12:54 PM
Change cell color everytime a value is selected in dropdown list	angelica_gloria	Excel	4	01-27-2012 06:47 PM