Ignore text in macro/VBA

[Batschin]

I'm building an Excel model in which I would like to add a function in VBA that prevents a macro from being executed if the value in a cell is in text format. Let's say that the user should fill out a number in a cell, but by mistake fills in a word or just some letters. I would like this to make a messagebox appear that requests the user to check that cell. At the moment I have an IF-statement that prevents the macro if the value is zero, but I would need this addition to "stop" the model if a cell containes text... Could someone help me please? Thanx...

 

[TheAceMan1]

How are ya Batschin . . .

Have a look at the [blue]IsNumeric[/blue] function:

[blue]   If IsNumeric([purple][b][i]YourCellExpression[/i][/b][/purple]) Then
      [green]'Your code here[/green]
   Else
      [green]'Your message here[/green]
   End If[/blue]

BTW . . . this is the [blue]Microsoft: Access Forms[/blue] forum . . .

See Ya! . . . . . .

 

[Batschin]

Ok, thanks AceMan, I'll switch forum