| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use VB to hide Row 57 if cell A53 has a value of 1?
I have a pricing worksheet. If the person filling it out populates the QTY
field (cell A53) of the item in row 53 with a value of 1, then I want the item in row 57 to "disappear", so it can't be selected also. Is there a VB code I can use to accomplish this? Thanks for your time! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use VB to hide Row 57 if cell A53 has a value of 1?
Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$53" Then Rows(57).Hidden = (Target.Value = 1) End Sub If this post helps click Yes --------------- Jacob Skaria "Dorothy" wrote: I have a pricing worksheet. If the person filling it out populates the QTY field (cell A53) of the item in row 53 with a value of 1, then I want the item in row 57 to "disappear", so it can't be selected also. Is there a VB code I can use to accomplish this? Thanks for your time! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use VB to hide Row 57 if cell A53 has a value of 1?
Worked perfectly. Thanks!!
"Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$53" Then Rows(57).Hidden = (Target.Value = 1) End Sub If this post helps click Yes --------------- Jacob Skaria "Dorothy" wrote: I have a pricing worksheet. If the person filling it out populates the QTY field (cell A53) of the item in row 53 with a value of 1, then I want the item in row 57 to "disappear", so it can't be selected also. Is there a VB code I can use to accomplish this? Thanks for your time! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the size of a cell and hide what is in the cell? | Excel Worksheet Functions | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
| How to hide a particular cell....... | Excel Discussion (Misc queries) | |||
| Hide Value of Cell | Excel Discussion (Misc queries) | |||
Linear Mode
