G
Guest
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.
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.