Thread: TextBox format?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
SpreadsheetBrian SpreadsheetBrian is offline
external usenet poster
 
Posts: 12
Default 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