How to hide command button based on another cell?

**proepert** · 01-16-2010, 05:54 PM

I have a command button on a worksheet, not in a user form. I know the command button has a property called Visible that I can manually set to False.

I want to set this property to False if the value of the B3 cell is less than 2.000

Thank you for helping me.

**martindwilson** · 01-16-2010, 06:24 PM

in the worksheet module

Please Login or Register  to view this content.

**proepert** · 01-16-2010, 07:10 PM

Thank you very much.

**paxile2k** · 10-22-2010, 02:00 PM

This code does help, i have a simular question on this issue, how do you have the button hide based on the value from another sheet in the workbook?

Here is the code i have, but not sure if it is correct:

<code>

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Worksheets("Reference").Range("L18") > 0 Then
Me.CommandButton1.Visible = True
Else
Me.CommandButton1.Visible = False
End If
End Sub

</code>

**martindwilson** · 10-22-2010, 05:02 PM

paxile2k
please start a new thread linking to this one if you want to

**tittbb** · 01-27-2014, 08:51 AM

Hi Martin,

I came across this thread with your VBA solution which fit the bill/works faultlessly for a small project I was doing however I only just realized it works for only 1 Button. Is there a way I can add additional buttons each referencing it's own individual cell? There is also one button which needs to show based on more than 1 cell.

I adjusted your code to suit the condition as I only need the button(s) to appear when an entry is mad in a specific cell. The buttons are used to clear a range of cells.

Please Login or Register  to view this content.

Any assistance would be greatly appreciated

Regards

Tui

**arlu1201** · 01-27-2014, 09:20 AM

tittbb,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Also, you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

**tittbb** · 01-27-2014, 09:28 AM

Ok understood the first part (what do code tags look like) however I don't get the second. How do I then get a response from the person who wrote the original code where they would be better placed to respond?