| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-down leading to more Cells
Hello everyone, I know this is possible but do not know how to make it. I have two options in a Cell as Applicable and Not Applicable. This is in a Drop-down menu and what I want is that when I choose Applicable, it should bring up additional 5 or 6 cells for me to complete. And if I choose Not Applicable, the additional cells should not show up. The default would be Not Applicable. Can somebody help please. Thanks in adance. -- bengaluru ------------------------------------------------------------------------ bengaluru's Profile: http://www.excelforum.com/member.php...o&userid=24188 View this thread: http://www.excelforum.com/showthread...hreadid=520139 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop-down leading to more Cells
Any help here please ??? -- bengaluru ------------------------------------------------------------------------ bengaluru's Profile: http://www.excelforum.com/member.php...o&userid=24188 View this thread: http://www.excelforum.com/showthread...hreadid=520139 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop-down leading to more Cells
bengaluru Wrote: Any help here please ??? Is there no one who can help me ? -- bengalur ----------------------------------------------------------------------- bengaluru's Profile: http://www.excelforum.com/member.php...fo&userid=2418 View this thread: http://www.excelforum.com/showthread.php?threadid=52013 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop-down leading to more Cells
Is your drop-down generated by DataValidationList ?
Or is it a combobox? -- AP "bengaluru" a écrit dans le message de ... bengaluru Wrote: Any help here please ??? Is there no one who can help me ?? -- bengaluru ------------------------------------------------------------------------ bengaluru's Profile: http://www.excelforum.com/member.php...o&userid=24188 View this thread: http://www.excelforum.com/showthread...hreadid=520139 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop-down leading to more Cells
I think this is a feasible solution. Your drop down should ideally be Data Validation on cells. Then you use conditional formatting to make the additional 3 cell appear when "Applicable" is selected and stay greyed out (defau format) when "Not Applicable" is selected -- jomn ----------------------------------------------------------------------- jomni's Profile: http://www.excelforum.com/member.php...nfo&userid=774 View this thread: http://www.excelforum.com/showthread.php?threadid=52013 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop-down leading to more Cells
Yes. My drop-down menu is generated by DataValidationList. Thank -- bengalur ----------------------------------------------------------------------- bengaluru's Profile: http://www.excelforum.com/member.php...fo&userid=2418 View this thread: http://www.excelforum.com/showthread.php?threadid=52013 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to drop leading zero in 0.700? desired result is .700 | Excel Discussion (Misc queries) | |||
| how do you remove leading spaces etc in cells? | New Users to Excel | |||
| I need to drop some leading zeros | Excel Discussion (Misc queries) | |||
| How do I add a leading 0 to a group of cells | Excel Discussion (Misc queries) | |||
| drop down box leading to another drop down box | Excel Discussion (Misc queries) | |||
![bengaluru[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
