Formatting values in a form control. Is it possible?

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

Is there a way to have a textbox on a form to display the value in a cell
exact as it is display on screen. For example, have 326.45 as a value in the
cell but I used custom format to display it as 326.45 Watts. Now I want this
to be the value in the txetbox on the form instead of just 326.45.
 
Is there a way to have a textbox on a form to display the value in a cell
exact as it is display on screen. For example, have 326.45 as a value in the
cell but I used custom format to display it as 326.45 Watts. Now I want this
to be the value in the txetbox on the form instead of just 326.45.
Click to expand...

Hello Ayo,

If your TextBox is on a VBA UserForm set the value property to the
cell's Text property...

TextBox1.Value = ActiveSheet.Range("A1").Text

Sincerely,
Leith Ross
 
Thanks a million Leith !!

Leith Ross said:
Hello Ayo,

If your TextBox is on a VBA UserForm set the value property to the
cell's Text property...

TextBox1.Value = ActiveSheet.Range("A1").Text

Sincerely,
Leith Ross
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

VB Date Format 8
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Formula appearing as Value in Formula Bar 1
Accounting Format Text in a Textbox 4
format label text 5
How to retrieve number of visible digits after decimal point in VBA 5
conditional format fails when copied 1
Text Formats 4

Back
Top