update formulas after any activex text box change on worksheet

[jed38]

I have 180 activex text boxes on a worksheet. I also have a UDF to get the values from the textbox to cells in other sheets in the excel file. the problem being a textbox change does cause excel to auto update formulas.

What I would like is to be able to update formulas anytime any of the textboxes are changed. Is there any way to do this other then having 180 textbox change events??

I have been googling and i keep seeing something with class modules. I have never used class modules. and found some stuff for textbox form controls in userforms.

Any help or suggestions??

[LJMetzger]

Hi jed38,

See the attached file, which should get you started. Please ask and/or post a sample workbook if you need any additional help.

See the following post for a similar question about Active X combo boxes: http://www.excelforum.com/excel-prog...-combobox.html

Lewis