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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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
417
FedElecQaEng
F
P
  • Question
Exiting a Textbox Problem
2
Replies
10
Views
296
Pacman52
P
N
  • Question
Automating textbox updates in PP using VBA to read excel data
Replies
0
Views
468
noobslayer252
N
K
  • Question
Run a vba Sub routine every xx seconds
Replies
1
Views
75
jkpieterse
jkpieterse
M
  • Solved
Display textbox from listbox - getting 381 error
Replies
4
Views
254
maiatanaka
M

Forum statistics

Threads
1,215,495
Messages
6,125,149
Members
449,208
Latest member
emmac

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