Results 1 to 3 of 3

Data Validation Macros

Threaded View

  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.

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