Thread: Formula for: If b6 is or = to 8333 then b6 should be 8333 HELP
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Formula for: If b6 is or = to 8333 then b6 should be 8333 HELP
On Fri, 6 Oct 2006 09:11:02 -0700, Help Me <Help
wrote:

Please help with this formual before I pull out my hair :) Also, there is a
formula in b6.

You cannot do that with a worksheet formula.

You can do that with an event-triggered macro.

Right Click on the sheet tab; select View Code; and paste the code below into
the window that opens.

Perhaps this will do what you wish.

==================================
Private Sub Worksheet_Change(ByVal Target As Range)
If IsNumeric([b6]) And [b6] < "" Then
[b6].Value = Application.WorksheetFunction.Min([b6].Value, 8333)
End If
End Sub
==========================


--ron
Reply With QuoteReply With Quote