Hi,

I have added an Active-X textbox to my spreadsheet and would like to use the textbox value in a spreadsheet formula. Somehow, the formula does not accept the textbox name as a parameter.

Textbox name: foo

Formula: =foo + 1

Does Excel support using Active-X control values in spreadsheet formulas?

Thx

Carsten

Hi Carsten,

Not directly, you have to assign a cell with the LinkedCell property which you can use in your formula.

Andreas.

• Marked as answer by MS2065 [MSFT]Microsoft employee 19 hours 21 minutes ago