+ Reply to Thread
Results 1 to 4 of 4

Manipulate bitmap color in VBA to simulate colorblindness

  1. #1
    Registered User
    Join Date
    09-04-2014
    Location
    Minnesota, USA
    MS-Off Ver
    2010
    Posts
    2

    Manipulate bitmap color in VBA to simulate colorblindness

    My boss is color blind, and I was thinking that if I could manipulate bitmap images, then I could see what he is able to tell apart and what looks just the same.

    I have found the transform matices for lots of different afflictions at http://web.archive.org/web/200810141...s/colormatrix/


    {Normal:{ R:[100, 0, 0], G:[0, 100, 0], B:[0, 100, 0]},
    Protanopia:{ R:[56.667, 43.333, 0], G:[55.833, 44.167, 0], B:[0, 24.167, 75.833]},
    Protanomaly:{ R:[81.667, 18.333, 0], G:[33.333, 66.667, 0], B:[0, 12.5, 87.5]},
    Deuteranopia:{ R:[62.5, 37.5, 0], G:[70, 30, 0], B:[0, 30, 70]},
    Deuteranomaly:{ R:[80, 20, 0], G:[25.833, 74.167, 0], B:[0, 14.167, 85.833]},
    Tritanopia:{ R:[95, 5, 0], G:[0, 43.333, 56.667], B:[0, 47.5, 52.5]},
    Tritanomaly:{ R:[96.667, 3.333, 0], G:[0, 73.333, 26.667], B:[0, 18.333, 81.667]},
    Achromatopsia:{ R:[29.9, 58.7, 11.4], G:[29.9, 58.7, 11.4], B:[29.9, 58.7, 11.4]},
    Achromatomaly:{ R:[61.8, 32, 6.2], G:[16.3, 77.5, 6.2], B:[16.3, 32.0, 51.6]}

    How do I manipulate a bitmap's color in vba?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Manipulate bitmap color in VBA to simulate colorblindness

    Maybe try this before going down the path of writing your own viewer. You will have to use different file format though.
    http://www.color-blindness.com/cobli...ess-simulator/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-04-2014
    Location
    Minnesota, USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Manipulate bitmap color in VBA to simulate colorblindness

    Thanks, Andy,

    That is an interesting resource. It will provide a useful check. It is limited in the size of an image, so it will not serve the main purpose, but will provide a check of what I do. Can you or anyone else point me to a resource that will tell me how to manipulate a bitmap pixel color in VBA? or tell me that it can't be done? I will happily accept either form of the answer, or this one if I don't get another answer.

    /g

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Manipulate bitmap color in VBA to simulate colorblindness

    That page took about 30 seconds to find with google so I'm sure there are others out there.

    It is possible to read a bmp if you know the structure. This is old so only does limited colours.
    http://www.andypope.info/fun/bmpconvert.htm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bitmap manipulation from VBA/VB
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-23-2017, 11:29 PM
  2. Drilling a bitmap
    By mickbarry in forum Excel General
    Replies: 1
    Last Post: 07-09-2014, 04:39 AM
  3. VBA Bitmap Resizing
    By yankees2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2012, 05:11 PM
  4. IF Statement with bitmap
    By 99f150 in forum Excel General
    Replies: 3
    Last Post: 03-17-2010, 09:47 AM
  5. manipulate color with code
    By Ningster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2006, 07:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1