Display in a textbox, the character count of a cell, when the cell is selected

Can we display character count in a textbox (placed in a sheet), when the cell is selected? Please suggest any better way of achieving this? I want to avoid the usage of button/msgbox.

How can i make this work for any cell i click on a worksheet? Also, i need to know if we can implement for a range of cells say A1:A10. I want to try both these cases.

Well, it depends. If you have just 1 textbox called textbox1 then its easy. If you have multiple textboxes I am going to need a lot more information. This will do range "A1:A10". You should be able to see the differnce to modify yourself.

Please Login or Register  to view this content.

Hi! Thanks for the response. I am using only one textbox to display character count of a cell. I tried your code, but somehow it didn't work for me Can you please suggest what i need to modify here?

Please Login or Register  to view this content.

Originally Posted by stnkynts

Well, it depends. If you have just 1 textbox called textbox1 then its easy. If you have multiple textboxes I am going to need a lot more information. This will do range "A1:A10". You should be able to see the differnce to modify yourself.

Please Login or Register  to view this content.

@stnkynts: Need help! Can you please help me resolve this?

This works just fine for me. Are you sure your using an ActiveX textbox titles TextBox1?

Please Login or Register  to view this content.

I used ActiveX textbox not sure why it isn't working for me. I hope i am clear in explaining what i am looking for. if not, I am trying to display the character count in a textbox when i select a cell.

Originally Posted by stnkynts

This works just fine for me. Are you sure your using an ActiveX textbox titles TextBox1?

Please Login or Register  to view this content.