Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text box linked to cell
How do I get text boxes to reference the contents AND THE FORMAT of a cell.
Using the control toolbox's properties and LinkedCell, I can get text boxes to reference numbers from a cell but not the format. For example, I want the text box to reference the same shaded color as what's in the cell and also only want one decimal point to be displayed. I will be transferring data into cells that will also contain conditional formatting to shade cells. I want this data to be displayed in text boxes on a silhouette the same as they appear in the cell. Sure hope someone can help. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text box linked to cell
Hi DJP,
Quite a tricky task ... with a lot of coding in an event macro to identify all cell attributes and get them replicated in textbox ... Would sound more reasonnable to look for another solution ... Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Chart title text linked from a cell? Possible? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions |