Format Textbox as %

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

I would like to format textbox1 as %.

If ComboBox1.Value = "Best Performing (%)" Or "Worst
Performing (%)" Then

format entry into textbox1 as % where the % auto attaches
on the end of the number.

For example, I chose the value "Best Performing (%)" from
combobox1. I then go to enter 10 in the textbox1. When I
type in 10 in textbox1, I would like for the % sign to
automatically show after the 10 so it look like 10%.


Thanx

todd
 
sStr = Application.substitute(textbox1.Text,"%","")
Textbox1.Text = sStr & "%"
 
Thanx

-----Original Message-----

sStr = Application.substitute(textbox1.Text,"%","")
Textbox1.Text = sStr & "%"

--
Regards,
Tom Ogilvy




.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
COMBOBOX AND TEXTBOXES QUESTION !! 6
Syntax To Update ComboBox List From TextBox 16
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Load Userform from Array using a Loop 4
Autofilter with optional criteria 3
Add Item To ComboBox List 7
Update Textbox1 after combox easy help for beginner! Opzioni 1

Back
Top