+ Reply to Thread
Results 1 to 1 of 1

if then else of ranges of a col that change the value of range of diff col values

  1. #1
    Registered User
    Join Date
    07-30-2012
    Location
    Shippensburg, PA
    MS-Off Ver
    office 2007, Frontpage and Visio 2003
    Posts
    22

    Question if then else of ranges of a col that change the value of range of diff col values

    What I am trying to to with vba

    If a cell in the cell.range of H4:H59 = "ORDERS" or "PD/ORDERS" or "TBA/ORDERS"
    then the corresponding cell in the same row of cell.range K4:K59 = DATA!Q6
    else = DATA!Q5 (DATA!Q6 is the flag symbol of Wingdings font, Size 11, Red color, Bolded) I already formated the cell in the col.
    * the flag symbol is DEC 79, or HEX 0x4F *

    The row K you can select from a drop down list the flag symbol if you wish, but I wanted to make it automatic to the status chane in row H.
    Also the drop down list for the orders col. show up as a blank which is fine, but the flag show up as an "o" which is supposed to be the flag. The same is true with Row F or EKG which gives you a blank or a heart, but you see a blank or a "Y" in the drop down list.


    Thanks in advance.

    Christopehr "Ferrum"
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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