MsgBox Issue

[nancybrown]

I would copy and paste this, but I'm not sure how, so I'll do my best to explain.

I have an excel spreadsheet. When a number is entered into a field that is less than .5, a Microsoft Excel msgbox window pops up with an error message that the user must enter increments of .5 . . . but I can't find where this rule is created . . I've checked conditional formatting . . . vba code . . . can anyone guide me on how find where I can find this so I can modify it please?

NB

 

[Snakehips]

Buck,

Sounds like there is a data validation rule in place?

With cell selected click Data tab DataValidation and take a look / amend as required.

 

[ranman256]

in the Worksheet change event...you can tell where and what they entered then warn them

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
vChr = right(activecell.value ,1)
if vChr <> 5 and vChr <> 0 then
   msgbox "You must enter in increments of .5",vbcritical,"Error"
end if
end sub

 

[nancybrown]

Hi Tony,

That was it!!! Many thanks for your help.