datavalidation

  1. RJSIGKITS

    VBA Message box to show if user tries to enter info into a cell when another cell is empty

    Hi. Could someone please help me with this, as I can't get it to work right. I need to add a message box VBA to my worksheet which forces a user to enter other data before they can enter data into a specific cell, as follows: User needs to add data on the worksheet, which fills Cell H1, in...
  2. A

    Can 1st Column Data validation (list) control 2nd Column vlaue list?

    Hi there, I need help with the data validation set up. I have 3 tables. Table1 name=activities (containing 2 data points, being used as a dropdown list using datavalidation on col D) Table2 name=SubActivities of activity1 (containing 2 data points, being used as a dropdown list with...
  3. S

    Show/Hide Several Sheets based on Data Validation

    Greetings, new user who is not a VBA pro and would appreciate help. I'm also working on a navigate sheets ribbon, which I can post/reciprocate when I finish. I'm working on a workbook, where the user will select from a list (datavalidation) with a range name "AssetType", and based on their...
  4. M

    Identifying unique data based on 2 criteria using the .find function

    Hi all, I am working on a macro that will take data from one workbook and move it into another scheduling workbook. When i transfer the data over to the scheduling workbook I need to check to make sure the data i am transferring is unique based upon two criteria, Job# and heat#. If the new data...
  5. K

    Not possible to extend series on data validation cells in protected sheet.

    I would like to protect shapes so I use the argument DrawingObjects:=True. However, with this argument set, it's not possible anymore to extend series on cells with a data validation list. In example, click on cell A1 and autofill the data to cell A10 won't work. The hand mousepointer appears...
  6. S

    Help with Multiple levels of Data Validation

    Hello, I'm looking to put a drop down list in a column E2:E32 which gives the option to select "White", "Gray", or "Black". I also want a countif to trigger a warning if a duplicate is entered in column E withn columns B through D of the same row. Is it possible to add two levels of data...
  7. S

    Data Type Error

    I am currently trying to use an OFFSET formula to declare a range for use in a Drop Down List. The formula works fine in a cell or range of cells however, when I try to use it in the Data Validation source it throws an error claiming something is wrong in the formula. After some investigation I...
  8. N

    Dependent cell data validation

    Hi everyone (I'm new)! I have an issue I cannot seem to figure out. -So I have 2 cells, B1 and B2 say. -If B2 is 0 I need B1 to stay 0 as well, but I need an error message to pop up if someone changes it. -If B2 is >0 B1 can be whatever manually entered number you want. So my steps to...
  9. T

    Unable to clear the contents of Datavalidation in excel using VBA

    Hi, I have a VBA function that will bind an array to excel range and in turn use that range to specify a data validation list for the selected range. I want to remove the datavalidation if the array that i'am passing is empty but this doesnt happen, i can still see the dropdown of previous...
  10. K

    Listbox MultiSelect

    I'm have a project at work where I want to make multiselections of a list. These selections will again appear in the next column (or next row). I've used datavalidation before, but I can then just make one selection, but I want to be able to make more than one selection from the list. Maybe me...
  11. N

    Error message when cell left blank

    Hi Community, I'm producing a template for auditing purposes and is going to be provided to outsourced companies to complete the task. I'd like to know if there is a data validation or macro that wont allow the auditor to leave a cell blank when he clicks on it because in the past we have had...
  12. T

    BeforeDoubleClick on Protected Sheet with DataValidation

    I have a protected sheet where users can make choices (by DataValidation) to certain cells. I want to use the "BeforeDoubleClick" event to let the users switch between the options. So if a cell holds "Option A" and "Option B", then doubleclicking would switch from "Option A" to "Option B" and...
  13. Jaafar Tribak

    Data Validation InCellDropDown

    Hi all. I need to have the dropdown of a cell with a data validation always on display without needing to have the cell selected and clicking on the arrow or pressing Alt + Arrow Key ? Any ideas ? Regards.
  14. D

    data validation, vlookup or what??

    I have a cost estimation spreadsheet. I have cell A6 pull data validation name list of hardware from another sheet. Then I have cell B6 pull data vlaidation name list of software from another sheet. Then they calculate into another cell and it works wonderful. What I am trying to do now is...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top