Command button Enable using VBA

**psatkar** · 11-10-2006, 03:11 AM

Hi,

On my excel sheet I have a button named Button14. I want to control if the button is enabled by comparing the contents of values in cells C25 and E25.

I have created another button named button50. In the click property of this button, I have written the following code:

Sub Button50_Click()

If [C25].Value = [E25].Value Then
Button14.Visible = True
Else
Button14.Visible = False
End If

End Sub

In excelsheet, when I click on Button50, it gives me an error "Runtime error 424" - object required. In debug mode, the highlighter in on the line
" Button14.Visible = True" from the above code.

Can someone help me in identifying what is it that I am doing wrong?

Thanks in advance.

Warm regards,
--Prasad

ps: Is there any way I can find out the "name" of the commnad button which I have already created and then renamed its text later?

**Mallycat** · 11-10-2006, 04:05 AM

try this

If range("C25").Value = range("E25").Value Then

**Bartek** · 11-10-2006, 04:59 AM

Hi,

Originally Posted by psatkar

In excelsheet, when I click on Button50, it gives me an error "Runtime error 424" - object required.

Your code should work, error 424 indicates that VBA cannot find Button14 - maybe there is a typo in the name of the button or in your code. Are Button50 and Button14 placed in the same worksheet? If not, you should reference a button along with worksheet name like: Sheet2.Button14.Visible=True.

**psatkar** · 11-10-2006, 05:30 AM

Is there any way I can find the name of the command button which I ahve created in worksheet.

I wanted to confirm the name of button Button14.

Warm regards,
--Prasad