Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box into a cell
Newbie list box question.
I would like to create a list box with entries from a named range "FRA" When I select a entry from the list box I would like to call a macro. Can someone help me with the code to create a listbox in whatever the activecell is? Thanks for the help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Box into a cell
Try: in cell C2
Data Validation List ( in sourse box write =FRA ) put this in Sheets-kode-window: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("C2")) Is Nothing Then Exit Sub MsgBox ("Selected list-value : ") & Target End Sub --------------------------------------------------------- is this another question ? Can someone help me with the code to create a listbox in whatever the activecell is? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
How do I set up drop-down list for a cell when the list is in ano. | Excel Discussion (Misc queries) | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions |