Command Button Problems Still

[Mikeice]

HI ALL

Now if I put in the a value and then delete the value the Command
Button 3 goes to disable but the Command Button 1 does not. I can't
understand why.

Please help, thx in advance




Private Sub Worksheet_SelectionChange(ByVal Target As Range)


If Sheets("Quality Accessing Template").Range("B6").Value >= "0" And
Sheets("Quality Accessing Template").Range("B6").Value <= "9999" Then
Sheets("Quality Accessing Template").CommandButton3.Enabled = True
Sheets("Quality Accessing Template").CommandButton1.Enabled = True


Else


Sheets("Quality Accessing Template").CommandButton3.Enabled = False
Sheets("Quality Accessing Template").CommandButton3.Enabled = False

End If

End Sub

 

[mangesh_yadav]

First thing, remove the quotes around 0 and 999
Second thing, you are not disabling the commandbutton1. Check your else
code, both are 3.

Mangesh

 

[Don Guillett]

and use with/end with


--
Don Guillett
SalesAid Software
(e-mail address removed)
"mangesh_yadav" <[email protected]>
wrote in message
news:[email protected]...