Whenever I input your code, an error message comes up saying there needs to
be a seperator. Also, after that code do I just start in with the Case 1...or
start with Case "E1: Circular Corrugated Pipe." And also, is there a way just
to clear text and not the whole cell. I have a border around the cell and do
not want to lose it each time the cell changes? Thank you!


Tom Ogilvy wrote:
>Change B9 to the cell you want to reflect the value of the TypeE combobox.
>
>Public Sub E1Pipe1_Change()
> Worksheets("Program").Range("B9").Value = _
> Worksheets("Program").DropDowns("("typeE").Value
>End sub
>
>> I have two comboxes in my worksheet. The first has 3 selections and each
>> selection changes the data in the second combobox, which has 7 selections.
>[quoted text clipped - 65 lines]
>> change the cells each time a user clicks on a different option. Any help
>> would be greatly appreciated!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200602/1