Tucker1991
New Member
- Joined
- Nov 28, 2011
- Messages
- 1
Hi everyone,
I'm hoping to gain some insight on the following issue:
I'm using the following VBA to format values to percentages in an activex text box:
This works great, however, when using print preview through VBA, this formatting is lost and the text box reverts to displaying the value in the "General" format.
I need to keep this text box formatting for when the worksheets are viewed in print preview and subsequently printed. Does anyone know of a solution or a work around for this problem?
Also, if it's important, the text box is linked via properties to a cell on another worksheet, users will not be entering values directly.
Many thanks for your time and responses.
I'm hoping to gain some insight on the following issue:
I'm using the following VBA to format values to percentages in an activex text box:
Code:
TB.Value = Format(TB.Value, "+#0.0# %;-#0.0# %")
This works great, however, when using print preview through VBA, this formatting is lost and the text box reverts to displaying the value in the "General" format.
I need to keep this text box formatting for when the worksheets are viewed in print preview and subsequently printed. Does anyone know of a solution or a work around for this problem?
Also, if it's important, the text box is linked via properties to a cell on another worksheet, users will not be entering values directly.
Many thanks for your time and responses.