| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Show a row based on data entry in another row
Hi Ivory Kitten,
I must be doing something wrong! It works once or twice then nothing happens! I'm copying it exactly. What does "nothing happens" mean? Lower case entries in B1, B2 or B5 are not converted to uppercase? Row 19 is not hidden or unhidden in reponse to changes in B4? There is nothing intrinsic to the Worksheet_Change code that would explain successful operation followed by failure. Perhaps, howevere, you have other code which may have turned off events. In the Immediate window, try typing: Application.EnableEvents = True and hit the Enter key. Now retry the Worksheet_Change code. --- Regards, Norman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide/Show a row based on data entry in another row
It's odd, I have no other codes, its working fine now. The case bit was
working and the hide/unhide row part was not. But it is now!? how do you change the hide/unhide so that it hides when empty or a certain value? "Norman Jones" wrote: Hi Ivory Kitten, I must be doing something wrong! It works once or twice then nothing happens! I'm copying it exactly. What does "nothing happens" mean? Lower case entries in B1, B2 or B5 are not converted to uppercase? Row 19 is not hidden or unhidden in reponse to changes in B4? There is nothing intrinsic to the Worksheet_Change code that would explain successful operation followed by failure. Perhaps, howevere, you have other code which may have turned off events. In the Immediate window, try typing: Application.EnableEvents = True and hit the Enter key. Now retry the Worksheet_Change code. --- Regards, Norman |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide/Show a row based on data entry in another row
Hi Ivory Kitten,
It's odd, I have no other codes, its working fine now. The case bit was working and the hide/unhide row part was not. But it is now!? I am glad that you have got it working. how do you change the hide/unhide so that it hides when empty or a certain value? Change: Rows(19).EntireRow.Hidden = IsEmpty(rng.Value) to Rows(19).EntireRow.Hidden = Not IsEmpty(rng.Value) --- Regards, Norman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
| Hide & Show Rows based on Check Boxes | Excel Discussion (Misc queries) | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| How do I hide spreadsheet range from data entry? | Excel Worksheet Functions | |||
| Macro to Hide/Show Columns based on control cell value | Excel Programming | |||
Hybrid Mode
