EXCEL报表在输入格里输入字体颜色为白色,跳出此格输入的字体就变成黑色是怎么回事
请你看看是这样吗?秘密就是下面两段代码。Private Sub Worksheet_SelectionChange(ByVal Target As Range)Target。Font。ThemeColor = xlThemeColorDark1If Target "" Then Target。 Font。ColorIndex = xlAutomaticEnd SubPrivate Sub Worksheet_Change(ByVal Target As Range)Target。Font。 ColorIndex = xlAutomaticEnd Sub。全部
请你看看是这样吗?秘密就是下面两段代码。Private Sub Worksheet_SelectionChange(ByVal Target As Range)Target。Font。ThemeColor = xlThemeColorDark1If Target "" Then Target。
Font。ColorIndex = xlAutomaticEnd SubPrivate Sub Worksheet_Change(ByVal Target As Range)Target。Font。
ColorIndex = xlAutomaticEnd Sub。收起