Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation
I would like to prevent users of a spreadsheet from
entering data into certain fields when they have made certain selections from a drop-down list. I have been looking at Visual Basic Help topics, and there are examples of data validation methods; however, when I copy the code (and modify it to my spreadsheet's needs), I am receiving compile errors "Named arguments not found." I am new to both Excel and Visual Basic; please help me. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation
Could you post the code that you are using?
-----Original Message----- I would like to prevent users of a spreadsheet from entering data into certain fields when they have made certain selections from a drop-down list. I have been looking at Visual Basic Help topics, and there are examples of data validation methods; however, when I copy the code (and modify it to my spreadsheet's needs), I am receiving compile errors "Named arguments not found." I am new to both Excel and Visual Basic; please help me. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation
Hi Matt,
I appreciate your efforts to help me. I recorded the code as a macro, and it worked! Thanks, Sisilla -----Original Message----- Could you post the code that you are using? -----Original Message----- I would like to prevent users of a spreadsheet from entering data into certain fields when they have made certain selections from a drop-down list. I have been looking at Visual Basic Help topics, and there are examples of data validation methods; however, when I copy the code (and modify it to my spreadsheet's needs), I am receiving compile errors "Named arguments not found." I am new to both Excel and Visual Basic; please help me. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |