Consulting

Results 1 to 4 of 4

Thread: Need help in Excel Macro

  1. #1
    VBAX Newbie
    Joined
    Apr 2012
    Posts
    2
    Location

    Need help in Excel Macro

    i have created a list Yes/No using Data validation . Now tell me how to do this -

    If i select "Yes" then nothing but if "No" then it shud give me an error msg.

    Also another instance where if i select Yes then the next row will hide.

    Pls if someone can help me

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,145
    Location
    Change the DV to only Yes and it will give the error message.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Newbie
    Joined
    Apr 2012
    Posts
    2
    Location
    Thanks for the help, but i want both the option and if a user select No then it shud throw an error

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,145
    Location
    If you are going to throw an error, what is the rationale for even havng that as an option?

    Pick A or B! Oh, you picked B, that is not allowed. It does not compute Jim!
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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