Display Percentages in a VBA Userform TextBox

bigbrownbear

bigbrownbear

Board Regular
Joined
Nov 21, 2006
Messages
92
I am having a referenced cell appear in a textbox. It is formatted as 3.5% but appears in the textbox as ,035324. How can I make it appear as a percent?

This seems like it would be a simple thing, but I can't figure out how to do it.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
Never mind. I always figure out these things right after i bug you guys. It is:

txtName.Value = FormatPercent(ActiveCell.Offset(6, 2))
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
Userform textbox launches another userform
Replies
8
Views
360
FedElecQaEng
F
P
  • Question
Exiting a Textbox Problem
2
Replies
10
Views
201
Pacman52
P
N
  • Question
Automating textbox updates in PP using VBA to read excel data
Replies
0
Views
449
noobslayer252
N
K
  • Question
Run a vba Sub routine every xx seconds
Replies
1
Views
39
jkpieterse
jkpieterse
M
  • Solved
Display textbox from listbox - getting 381 error
Replies
4
Views
217
maiatanaka
M

Forum statistics

Threads
1,214,991
Messages
6,122,628
Members
449,095
Latest member
bsb1122

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top