+ Reply to Thread
Results 1 to 3 of 3

Data Validation Macros

  1. #1
    Registered User
    Join Date
    12-17-2011
    Location
    Riga,Latvia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Exclamation Data Validation Macros

    Hi!

    I got problems to make macros for specific task. I'm new to VBA so it's very complicated for me. Please help!

    Here is the picture for my task to better understand
    Macros.jpg
    1)In the Type collumn must be allowed only three values - "Meal","Income","Educat" and it needs to pop out warning if other values are entered(Warning 3)
    2)"Income" must be allowed only if there is entered value in Income collumn and "Educat" and "Meal" must be allowed only if there is entered value in Expense collumn. Also there needs to be warning in both cases.(Warning 1)
    3)Value can be allowed in Type collumn only if there is no value set in Subtype collumn. And warning of course(Warning 2).

    I've searched the web with no results
    Attached Files Attached Files
    Last edited by Helion23; 12-19-2011 at 09:29 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Data Validation Macros

    have you attached your sheet (not image)? I seem to be missing it

  3. #3
    Registered User
    Join Date
    12-17-2011
    Location
    Riga,Latvia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Data Validation Macros

    I attached my workbook.
    Last edited by Helion23; 12-19-2011 at 11:17 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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