Function of function of cell reference in data validation.

**Borkar2018** · 11-09-2018, 09:41 AM

Hello guys,

can you give me a hint how to do this? I want to define a macro that creates data validation for cell U2 like this (locale is German):

Please Login or Register  to view this content.

It throws an error because it cannot deal with

Please Login or Register  to view this content.

.

What I am actually trying to do is the following. Cell U2 contains a fiscal year of the format YY/YY, like 18/19, or 19/20, etc. I want to ensure that the first number is 1 smaller than the second, so I tried this

Please Login or Register  to view this content.

Whats the mistake I am doing?

Many thanks for any suggestions.

Borkar

**Richard Buttrey** · 11-09-2018, 09:53 AM

You can test that the first number is smaller with

Formula:

Please Login or Register  to view this content.

When using an Excel function in VBA code you should precede it with the

Please Login or Register  to view this content.

syntax. And don't forget if the formula contains literal quotes then these need to be wrapped in a second set of "" quote marks.

So, (untested)

Please Login or Register  to view this content.

**rorya** · 11-09-2018, 10:03 AM

For data validation in VBA, the formula must be entered exactly as you would enter it in a cell, not in US formats. So if you normally use a semicolon and german function names for example, you must use those in the code too.

**Borkar2018** · 11-12-2018, 04:27 AM

Thanks, I got it now!

I would like to thank you in particular for the quick replies! :-)

Function of function of cell reference in data validation.

LinkBack

Thread Tools

Rate This Thread

Display

Function of function of cell reference in data validation.

Re: Function of function of cell reference in data validation.

Re: Function of function of cell reference in data validation.

Re: Function of function of cell reference in data validation.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] IF function with INDIRECT reference for Data Validation source causing issue

Function to return the name of worksheet that contains the data in cell which is reference

Indirect Sheet reference with cell reference left function and text

Offset function with reference cell equal to the value of match function

Filtering Data with a function or cell reference

Inserting an INDEX,MATCH function into a HYPERLINK function instead of cell reference

[SOLVED] IF Function - If the reference cell data is presently unknown

Bookmarks

Bookmarks

Posting Permissions