+ Reply to Thread
Results 1 to 3 of 3

If statement which automatically populates another column based on a value

  1. #1
    Registered User
    Join Date
    09-08-2015
    Location
    Spain
    MS-Off Ver
    2013
    Posts
    8

    Question If statement which automatically populates another column based on a value

    Hi,

    I am new to VB and I want to create an If/Then statement but I am not sure how to do this

    Below is the code which sets UDF2 as the value <> str2 and then when a value is selected from this list; this is saved in UDF2.

    Please Login or Register  to view this content.
    What i would like this to do is store the selected value in UDF2- If the selected value = "A" then UDF2 is populated with value "A" and this also automatically populates UDF3 with value "B"

    Below is what i have tried; I am not sure which order the code should be in or if this is even the correct way for the If and Then condition?

    Please Login or Register  to view this content.

    Can anyone help?
    Last edited by Soneeka; 09-25-2015 at 02:02 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,082

    Re: If statement which automatically populates another column based on a value

    post deleted
    Last edited by protonLeah; 09-25-2015 at 02:44 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-08-2015
    Location
    Spain
    MS-Off Ver
    2013
    Posts
    8

    Re: If statement which automatically populates another column based on a value

    Thank you, I have edited my question

+ 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. Formula/Macro that populates cells based on criteria
    By adroit233 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2015, 05:49 AM
  2. IF Statement that populates a Month based off of specific Date Ranges
    By cmorten82 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-12-2014, 11:37 AM
  3. [SOLVED] Automatically Adding a IF Statement To A Column Of Existing Formula's
    By GEANZ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2013, 12:50 AM
  4. table automatically populates based on information in other tabs
    By ea223 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-27-2013, 10:10 PM
  5. Need to generate a random serial number that automatically populates the transmittal sheet
    By chriscole412 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2012, 12:52 PM
  6. Replies: 3
    Last Post: 07-11-2012, 05:20 AM
  7. Replies: 1
    Last Post: 02-06-2012, 02:25 AM

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