Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextBox format?
I have a linked a textbox with a cell which has a value in '[h]:mm'. I am not
able to format the textbox to display the same value as the cell (ie '[h]:mm'). Can anyone help? -- AOU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextBox format?
Best to load it formatted rather than link
TextBox1.Text = Range("A10").Text -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AOU" wrote in message ... I have a linked a textbox with a cell which has a value in '[h]:mm'. I am not able to format the textbox to display the same value as the cell (ie '[h]:mm'). Can anyone help? -- AOU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextBox format?
Thanks Bob,
But it`s not working. I get the initial figure come up but as it changes in the cell, it does not change in the textbox. I dont know why! -- AOU "Bob Phillips" wrote: Best to load it formatted rather than link TextBox1.Text = Range("A10").Text -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AOU" wrote in message ... I have a linked a textbox with a cell which has a value in '[h]:mm'. I am not able to format the textbox to display the same value as the cell (ie '[h]:mm'). Can anyone help? -- AOU |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextBox format?
You would have to handle it every time it changes, there is nothing
automatic with this I am afraid. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AOU" wrote in message ... Thanks Bob, But it`s not working. I get the initial figure come up but as it changes in the cell, it does not change in the textbox. I dont know why! -- AOU "Bob Phillips" wrote: Best to load it formatted rather than link TextBox1.Text = Range("A10").Text -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AOU" wrote in message ... I have a linked a textbox with a cell which has a value in '[h]:mm'. I am not able to format the textbox to display the same value as the cell (ie '[h]:mm'). Can anyone help? -- AOU |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
TextBox format?
I have a linked a textbox with a cell which has a value in '[h]:mm'. I am not able to format the textbox to display the same value as the cell (ie '[h]:mm'). Can anyone help? -- AOU Do this: 1) Put 12:34 in Cell A1 and format it however you see fit 2) create a textbox by clicking the textbox tool and drawing the textbox rectangle with your mouse pointer 3) go to the formula bar and type in "=A1" and press ENTER. Your text box is now linked to cell A1 and will update accordingly. Format and all. This works across tabs and across workbooks. Brian Herbert Withun |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox date format. | Excel Discussion (Misc queries) | |||
Date format textbox | Excel Discussion (Misc queries) | |||
format textbox to time | Excel Discussion (Misc queries) | |||
TextBox Format | Excel Discussion (Misc queries) | |||
Format numbers in Textbox | Excel Discussion (Misc queries) |