| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell value when selection made from drop list in anothe
Mike H: Where is your response?
-- Bob D Pirate "Mike H" wrote: Hi, setting the linked cell will fail if you do it like this. see my response Mike "bobdpirate" wrote: Please help me someone. I'm new at VBA but I know VB. I have several cells with drop down lists. For example, column D rows 1-5 have drop down lists associated with them. When I click on the cell, the list pops up and I select a value. When that happens, I want to search for the selected text in column C. I then want to copy the values of columns C and D in the row where the text was found and paste those values in column E and F on the row where the drop down list was activated. I know this sounds complicated, and I hate to ask for someone else to write code for me. But this is a one time job that I need to do and I don't have time to become well versed in VB for Excell. I would appreciate the help. I am a Labview expert and I often help and write small code for other beginners in the Labview forum. So I guess I'm doing my part in one language and would like help in another language in return. -- Bob D Pirate |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation drop down list selection change | Excel Programming | |||
| Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
| Having A Macro Run When A Selection Is Made In A List Box | Excel Programming | |||
| Drop Down List Selection... Then go to The Cell / Range | Excel Programming | |||
| Macro to change list box input range based on selection made in another cell | Excel Programming | |||
Hybrid Mode
