Hi,
When I open my userform I would like to copy the cell value and colour via VBA to my userform label but the problem is my cell has a gradient in it.
If coping the gradient isn't an option, is it possible for VBA to find 1 of the colours of the gradient?
Basically my cell has a center gradient fill consisting of colour 1 = white and colour 2 = red. I would like the label to be red when the userform is opened.
Lets say my cell is A1 and the userform label is Label1.
Any help would be appreciated.
Thanks
Dan
When I open my userform I would like to copy the cell value and colour via VBA to my userform label but the problem is my cell has a gradient in it.
If coping the gradient isn't an option, is it possible for VBA to find 1 of the colours of the gradient?
Basically my cell has a center gradient fill consisting of colour 1 = white and colour 2 = red. I would like the label to be red when the userform is opened.
Lets say my cell is A1 and the userform label is Label1.
Any help would be appreciated.
Thanks
Dan