| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for copying values from the dropdown list in Excel
Hi simon, I tried the below formula using insert function: =CHOOSE(B4,1,2,3,4,5,6,7,\"INVALID\") [/b] HERE AM ABLE TO COPY THE VALUES FROM DROPDOWN LIST (B4,WHICH HAS DROPDOWN LIST CONTAINING \"1,2,3,4,5,6,7,INVALID\") TO D4 ROW OF THE SAME SHEET,ONLY IF IT IS A NUMBER(1,2,3,4,5,6,7) .FOR \"INVALID\" OPTION IT GIVES ERROR AS [b]#VALUE! I am not able implement this for a dropdown list containing strings/alphabets. Also i need to add a textbox once the user selects "invalid" option from the dropdown list. Please help in solving this.:( Reply from any expert is greatly appreciated!!!. -- Tulsi ------------------------------------------------------------------------ Tulsi's Profile: http://www.thecodecage.com/forumz/member.php?userid=263 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90769 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restricting values in a cell that already has a dropdown list in i | Excel Programming | |||
| Dropdown List from values in a Cell Range | Excel Programming | |||
| How do I trigger a macro by selecting from a dropdown list? | Excel Programming | |||
| Allow selection of multiple values in dropdown list in excel | Excel Discussion (Misc queries) | |||
| dropdown list to activate Macro | Excel Programming | |||
Threaded Mode
