Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB to dsiplay value from drop down list
Hi, is there a way to use code to display the value selected from the
drop down list directly on a specific cell? I originally used the vlookup function and it worked well. However, I have added the following code to my two related drop down and the vlookup function for matching the value of drop down 2 is no longer working. Could anyone please help me out? If VB code is required, where should I put it? Thanks in advance. Option Explicit Sub ddMstr() Dim dd As DropDown Dim dd1 As DropDown Set dd = ActiveSheet.DropDowns(Application.Caller) With dd If .ListIndex 0 Then Set dd1 = ActiveSheet.DropDowns("drop down 2") dd1.ListFillRange = Worksheets("sheet2").Range("list" _ & dd.ListIndex).Address(external:=True) dd1.ListIndex = 0 End If End With End Sub Sub ddSub() Dim dd As DropDown Set dd = ActiveSheet.DropDowns(Application.Caller) With dd If .ListIndex 0 Then End If End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dsiplay numbers in Arabic language | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
How do I dsiplay changes in my cell | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Dsiplay Printer dialog | Excel Programming |