Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a sheet with 2 commandbuttons on it.
I want button1 to be visible if the total just above it is over 2500. Should the total be below that level, I would like button 1 to be invisible and button 2 to be visible Can it be done, How? Thanks -- Norton Professional 2004 says this email is clean...believe it |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
PCOR wrote:
I have a sheet with 2 commandbuttons on it. I want button1 to be visible if the total just above it is over 2500. Should the total be below that level, I would like button 1 to be invisible and button 2 to be visible Can it be done, How? insert the following procedure into the code module of the sheet: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(0, 0) < "F10" Then Exit Sub CommandButton1.Visible = Target.Value 2500 CommandButton2.Visible = Target.Value <= 2500 End Sub -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I print different areas of a spreadsheet using CommandButtons | Excel Discussion (Misc queries) | |||
Make CommandButtons Not Visable With A Macro | Excel Worksheet Functions | |||
delete commandbuttons on copied sheet | Excel Programming | |||
Do While, OnTime and CommandButtons | Excel Programming | |||
commandbuttons properties | Excel Programming |