Linking Maxlength to a cell.

[countryfan_nt]

Hello friends,

I have an excel sheet with a textbox, I want to link the maxlength of letters. I don't want to type a number, instead I want to place cell "R45".

There is a number that is changing.

Is it possible to have maxlength linked to an exisitng cell?

Thank you
Nawaf

 

[hatman]

You can't really make a dynamic link, but what you can probably do (I have never tried this, but there is no reason why it shouldn't work) is to place code in the WorkSheet_Change event that updates the Textbox.MaxLength property to whatever value is in that cell.