Posted to microsoft.public.excel.programming

Roger on Excel Roger on Excel is offline

external usenet poster

Posts: 249

Preserving number format in userform textbox

Is there a way to preserve the number format that is in a userform text box
to be the same as the formatting in the sheet source cell

For example 85% in the sheet (percent format) reads 0.85 in the text box
that reads from that cell

Can anyone help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format TextBox on UserForm	ryguy7272	Excel Programming	7	August 5th 07 03:46 PM
Number format of textbox in userform	Bikash	Excel Programming	3	June 27th 07 07:40 PM
format textbox in userform	jeffP	Excel Programming	1	January 25th 05 01:10 AM
Format of a TextBox in a userform	MD	Excel Programming	4	January 13th 05 05:42 PM
Qn: Date Format in TextBox in UserForm?	Michael Vaughan	Excel Programming	1	August 23rd 04 10:03 AM

All times are GMT +1. The time now is 06:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us