Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read List1 and write List2
This is a 2 part question.
1. I create 2 lists, List1 on column A and List2 in column B. List1 and List2 are linked to a Forms ComboBox and can be switch from one list to the other via 2 OptionButton. List1 is the narrative of a job and List2 is the acronym/code for the narrative. What I do is look at the narrative and then click on one of OptionButtons to switch to the acronym and click on it to trigger a macro to paste that/ code to a preselected cell. This works fine, but I would like to change it to something more stream line, like I see the Narrative(from List1) on the combobox and when I click/choose one of the values it narrative it writes the code. ie; I select the value "Photograph difficult matter" and it writes PDM on a selected cell. I had some ideas(Vlookup) but I was not able to make it work Any guidance will be appreciated 2.When I created the Forms combobox and the I change form List1 to Liist2 via clicking on OptionButtons the combobox will automatically refresh to the respective cell, meaning the value of A2 would change to the value of B2 by switching Option Boxes. The question is, when I create a Control Combobox It Will not refresh automatically, is there something I can do to autorefresh. Thank you very much for your help Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read only and write only | New Users to Excel | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
I have a list1 and a list2, I want to remove list2 from list1 | Excel Worksheet Functions | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
write to/read from add-ins | Excel Programming |