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...
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...
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...
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 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.