Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gkcchowdary
Creator
Creator

How to highlight the associate list box values in green color?

Hi,

Generally if select any value in list box it's highlight green color and associate list box highlight with white color.

My requirement is when I click any list box associate fields also highlighted in to green color.it is possible ?

Thanks

1 Reply
Anonymous
Not applicable

Hi Chaitanya,

For Changing the Default selection colour please follow the following procedure.

1. From the Tools menu, select Edit Module (or press Ctrl + M).

2. Enter the following code:

Sub SetColorPrefs()

Dim UserPrefs

set UserPrefs = _

ActiveDocument.GetApplication.GetUserPreferences

' Set the "Selected" Color

UserPrefs.CustomSelBgColor(1).PrimaryCol.Col = _

RGB(0,255,0) ' Green

UserPrefs.CustomSelFgColor(1).PrimaryCol.Col = _

RGB (0,0,0) ' Black

' Set the "Possible" Color

UserPrefs.CustomSelBgColor(2).PrimaryCol.Col = _

RGB(173,255,47) ' Light Green

UserPrefs.CustomSelFgColor(2).PrimaryCol.Col = _

RGB (0,0,0) ' Black

  ' Set the Excluded Color

UserPrefs.CustomSelBgColor(5).PrimaryCol.Col = _

RGB (200,200,200) ' Light gray

UserPrefs.CustomSelFgColor(5).PrimaryCol.Col = _

RGB (0,0,0) ' Black

' Set the Locked Color

UserPrefs.CustomSelBgColor(0).PrimaryCol.Col = _

RGB (255,0,0) ' Red

UserPrefs.CustomSelFgColor(0).PrimaryCol.Col = _

RGB (0,0,0) ' Black

ActiveDocument.GetApplication.SetUserPreferences _

UserPrefs

end sub

3. Click on the Check button to test for syntax errors. It should display "*** Ready ***".

4. Click on the Test button to execute the code.

5. Click on OK to close the editor.

6. From the Settings menu, open Document Properties (or press Ctrl + Alt + D).

table.PNG

7. Under Color Scheme, select [Custom]. Click on OK. 8. Note that the new color scheme has been applied.

May this will help you.

Note: You can change Color as per your choice for this just change the RGB Code.