To judge a number now and in the cell number is equal to how to write any
Cell is the text?

CodePudding user response:

What do you cell? DGV or excel? DGV word is very simple, to find out the cell's text, use the split () ", "separate into an array, and then judge array contains the number of line you give,

CodePudding user response:

With the Access

CodePudding user response:

Using the Contains (), the number of your first converted to a string

CodePudding user response:

Loved the

reference 3 floor response:

using the Contains (), your number first converted to string

Contains is not directly, have 1,20,3 find 2, also can be found, if stitching a comma before and after the

, 1,20,3, 

, then use splicing comma to find

, 20, 

, while it is possible to solve, but is not convenient, also not directly determine whether after the split segmentation in the collection is rigorous,

CodePudding user response:

Dim as string="1" s
Dim to_match as string="1, 2, 3"
If the split (to_match, ", "). Any (Function (x) x=s) then
.