data vaidation

  1. B

    How to go about retrieving data from data validation in cell to and listbox or textbox in userform

    I am creating a spreadsheet that holds a list of part numbers with their corresponding information. Right now I have it so that a textbox in userform entered like this (aaa-123,bbb-456,ccc-789) turns into a data validation in a cell within the same row as the part number. This is done because...
  2. T

    checking two date son user form

    Hi all, I've got two text boxes where users input the dates in specified format (dd/mm/yyyy). current validation checks whether one date is not earlier than the other one and it looks like this: If CLng(CDate(strToDate)) > CLng(CDate(strFromDate)). however if they are equal which suits me I am...
  3. F

    validation list

    hi, in Sheet2 I have list: <tbody> columnA (name) ColumnaB (region) Audi Euro Ford USA Chevi USA VW EURO Porshe EURO </tbody> I used manager name to define range: Cust_Name = Sheet2!$A:$A Reg_Name = Sheet2!$B:$B Now, in Sheet1 I did data validation and I have: A2 = list of name...
  4. D

    Data Validation - Use Sharepoint List

    Is it possible to use Data Validation pointing to a "Sharepoint List" ? I know you can use this in Access, just wondering if / how it could be used in Excel. Thanks Dave

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top