input message

  1. J

    change data validation after alloweditranges password was entered

    We have a spreadsheet which has ranges that are password protected (i.e. using AllowEditRanges with a password). This is not because we don't want users to be allowed to ever change those cells, but rather it is to prevent them from changing them accidentally. Users are provided with the...
  2. E

    Hide Column

    Kindly I need your help in this: I work in a glass industry. I have 12 processes in the plant (Cutting, Edging, Drilling...) These processes are put in Cells B16 --> B27 I did an excel file for my planning. Each order is a column in Excel (column C till Column ZZ) And for each order there's an...
  3. S

    Showing input message on Locked/protected cells

    Is there any way where you can show the input message that has been placed on a cell that is locked/protected? Basically I want the message for the cell to show up but dont want the user to be able to change it. thanks in advance
  4. P

    VBA Data Validation - Input Message

    Hi All, I'm working with a table where I've set an Input Message box to appear in each cell of a table. Now my question is, can I by VBA designate the Input Message box to a specific area on the spread sheet? I think the Input Message box is important, but am finding it annoying at times in...
  5. C

    Data Validation Input Message change

    Hi all, I have a worksheet that has about a dozen validation input messages on..... I have this code for the message i want to include Sub Add_Cell_Input_Message_Cell() With Range("HREndCurrentProjectStage_ForecastDate").Validation .Add Type:=xlValidateInputOnly .InputTitle = "Date Entry"...
  6. U

    Is there a way to position the Data Validation, Input Message?

    I have Data Validation set on cell A3 but every time the cell is selected the message is just below it and half off the left side of the screen. The Title says, "PROJECT NUMBER" and all you can see is, "CT NUMBER" unless the user moves the message. Is there a way to move the message to the right?
  7. J

    Data Validation Input Message: Possible to be Dynamic?

    Cell A1 uses data validation to restrict range to be within values of cells B1 and C1. Values in B1 and C1 are set from day to day and need no validation. The A1 data validation includes an input message. Is it possible to include in the text of the input message the min/max allowable values...
  8. D

    Data Validation Message box :: want to relocate

    Prev : 2003 Now : 2010 ... I use the Data Validation Message box that pops up when you sit on a cell, to deliver data entry user instructions ... But often the popup box would cover / overlay other nearby data, making point-and-click navigation to those covered cells difficult, at best. When...
  9. K

    Conditional Data Val Input Message

    I'm trying to find a way to have the Input Message (from the Data Validation tool) of cell A2 display a message depending on the content of the A1. A1, also data validated, has five possible values and I want that to trigger five different input messages for A2. The purpose is to guide users...
  10. B

    Data Validation Input Message Viewing and Printing

    Hi all, I have a spreadsheet that has Data Validation Input Messages for when cells are selected. I am after a way to view all of these at once and print them, I thought this would be achieved the same way that comments are viewed and printed, however can not find how to do it. Thanks in advance

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...