Excel forms combo box problem

[ed.ayers315]

Hi Folks,

I have a combo box that is 1st in the tab order Control Source c15, the second combo box RowSource is set to Indirect(c15).

I have to close the form before c15 is updated with the new value before my indirect function works.

Is there something I can do to stay in the form view and get c15 updated with the selected value?

Thanks for any help!

 

[Norie]

Glad you got it sorted but I don't know why you put the ControlSource back, but if it works it works.

 

[ed.ayers315]

So that they show below in the worksheet. These are the title/subject and subtitle for each entry.

Excel Workbook
	B	C	D	E	F
45
46
47	CIP_No.1
48	Crystallizer #1
49
50	CIP_No.2_Cheddar
51	OST #1 Short Wash
52
53	CIP_No.1
54	Raw Silo #2
55
LINES

Thanks again Norie<!-- ######### End Created Html Code To Copy ########## -->