Greying out buttons based on cell contents

Hi,
Complete newbie to VBA stuff, here is a question:
I have a spreadsheet with values in the certain cells and several buttons which carry out various functions however I would like the buttons to be only available if certain cells contain certain values. Therefore if a value isnt present i.e. empty in a certain cell (say A1) then I would like the button to be greyed out or visibly different than 'available' buttons (i.e. buttons that can be clicked because values are present in the cells required.
Hope this makes sense, thanks

Just a form control button will suffice. cheers

form control

Thanks DILIPandey,

how do I make the the button 'not available' if the value in A1 is nothing i.e. null?

I tried changing the 1 to a "Null" as well as Null but doesnt seem to work, what am I missing here?
If Range("a1").Value = "Null" Then

Also what does the following do in the VBA script? (sorry for my lack of knowldge on VBA!!)

'Entry point for RibbonX button click
Sub ShowATPDialog(control As IRibbonControl)
Application.Run ("fDialog")
End Sub

'Callback for RibbonX button label
Sub GetATPLabel(control As IRibbonControl, ByRef label)
label = ThisWorkbook.Sheets("RES").Range("A10").Value
End Sub

cheers

ok just figured it out:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("a1").Value = "" Then
CommandButton1.Enabled = False
Else
CommandButton1.Enabled = True
End If
End Sub

next question if I want the range to be multiple cells how do i do this? I have tried e.g. (a1:a4) but this doesnt seem to work? Suggestions? cheers

...also how about multiple blocks of cells e.g (a1:a4) and (d1:d4) etc
(Apologies for the series of questions) cheers

Another question:

The value in cell "a1" is derived from a Vlookup statement which in turn comes from a drop down list. Choosing a new item from the list updates the value in cell "a1" which should either make the button active or not active however this doesnt do it 'live' and immediately, it is only when I click in another cell that the button changes state. How do I get the button state to change immediately after selecting a field in the drop down list?
cheers

not sure I understand!
If for example there is ANY text in cells A1:A3 AND C1:C3 AND F4:F7 then I want the button to be available, if there is no text at all in these cells then the button should be disabled. Could you provide an example?

Also as mentioned the values in the the cells can change (these are VLOOKUP cells) dependant upon what is selected via a drop down list, when the contents of the list is changed the cells update straight away but the button only updates whether it is available or not when I click on another cell, how can I ensure the button changes state immediately. Again any examples? Thanks

Hi DILIPandey,

I thought this was the one! Unfortunatley if the cells have an formulas in them then the code doesnt appear to see the cell as empty. The code works fine if text is filled manually into the cells however I have VLOOKUP statements in the cells therefore even when the cell reports back empty the code still seems to see the formula in the cell thus assumes it isnt empty. How can this be resolved? cheers

attachedTest.xlsm