• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do I get a form TextBox to show 9% vs. .09?

T

txfrazier

New Member
I'm looking for VBA code to have TextBoxes maintain the formatting that the ControlSource has on the actual spreadsheet. I've searched throughout Chandoo but haven't been able to find any VBA code or if there are properties on the TextBox that will do this.


Thanks


Thomas
 
Hi, txfrazier!

Controls with linked cells as TextBox do just that: as they're linked to a cell they always displays it cells content. And in this work, content, is the key: they stick to the contents and not to the format that might have been applied to the cell. so I'm afraid you'd have to use a helper cell formatted as text and link this to the control.

Regards!
 
You must log in or register to reply here.
Back
Top