RE: Identifying negative numbers in a Rowsource Listbox...
The Rowsource of Listbox1 on Userform1 is A1:A5 and has these values
Is there a way to identify and display the negative values in A3 =-3 and A4 =-1
in this Rowsource in Textboox1 and Textbox2 on Userform1 and have them display as
(3) and (1) in red fonts using something like Textbox1.Font.Color = red ?
I'm not experienced enough on using an array as a Listbox Rowsource and using code to identify negative elements of the array if that is one way to do it if nothing simpler can be done
Would appreciate anyone's help with this very much.
Thanks, cr
The Rowsource of Listbox1 on Userform1 is A1:A5 and has these values
Code:
A1 =1
A2 =2
A3 =-3
A4 =-1
A5 =1
in this Rowsource in Textboox1 and Textbox2 on Userform1 and have them display as
(3) and (1) in red fonts using something like Textbox1.Font.Color = red ?
I'm not experienced enough on using an array as a Listbox Rowsource and using code to identify negative elements of the array if that is one way to do it if nothing simpler can be done
Would appreciate anyone's help with this very much.
Thanks, cr