IanTrout
02-23-2008, 12:59 AM
I was trying to make a simple macro command to color some cells in excel, but i want to input the cell range and color myself.
I tried to create my own form that would contain some a text box for the cell numbers and i copied the generic code generated by the macro and changed the given cells with string type variables and an int for the color itself. I didn't work that well... :)
My guess is that the variables are just from the wrong type... Which type should i use? and is there a better was of doing what i want to?
And on that note, this is my first post, so hi everybody... :hi:
Thanks in advance,
Ian Trout
I tried to create my own form that would contain some a text box for the cell numbers and i copied the generic code generated by the macro and changed the given cells with string type variables and an int for the color itself. I didn't work that well... :)
My guess is that the variables are just from the wrong type... Which type should i use? and is there a better was of doing what i want to?
And on that note, this is my first post, so hi everybody... :hi:
Thanks in advance,
Ian Trout