Good Morning!
I'm trying to show informations with R$ and % in textbox but for 5% text box show 0,05. Textbox to present % can receive number or text.
Is need to use Format tool?
Tnx for Help!
You need to format the number when you place it into the text box or change it with an afterchange event macro
Me.TextBox1.Value = Format(0.05, "0%"
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Very nice!
Tnks for help Mudraker.
Just dont know how to turn this post to "SOLVED"
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks