Consulting

Results 1 to 2 of 2

Thread: Need to build a macro with the following logic. Don't know how to start!

  1. #1

    Need to build a macro with the following logic. Don't know how to start!

    Hi,

    I am trying to build a macro for the logic below. I am a newbie with VBA and macros. I would appreciate any help.


    rwy, rwy2, rwy3, rwy4 are headers for fields in an excel table. They are values in the range of C8:I110. I need them to return "no value" or a configuration number in column J, lets call it "Configuration". I dont know which dimensions to create and how to use them or if we could use some sort of loop.

    If

    (rwy is empty) or
    (rwy2 is empty) or
    (rwy3 is empty) or
    (rwy4 is empty) or

    then print "No Value"

    elseif (both rwy & rwy2 have some numerical, date or alphabetic value and are not empty) has value then config1
    elseif (both rwy & rwy3 have some numerical, date or alphabetic value) has value then config2
    elseif (both rwy & rwy4 have some numerical, date or alphabetic value) has value then config3
    elseif (both rwy2 & rwy3 have some numerical, date or alphabetic value) has value then config4
    elseif (both rwy2 & rwy4 have some numerical, date or alphabetic value) has value then config5
    elseif (both rwy3 & rwy4 have some numerical, date or alphabetic value) has value then config6


    end if
    Please help any way you can.

    Thank you so much,
    Bhrigu
    Last edited by bhrigu; 08-09-2018 at 08:51 PM.

  2. #2
    In your other post, read the forum rules (#8) about cross posting.

Tags for this Thread

Posting Permissions

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