User Input

• • Reply

  13 years ago

  by gajulauma

  umasankar gajula

  , India

  Joined 13 years ago

  I was trying to make a simple macro command to color some cells in excel, but i want to input the cell range myself.

  I tried to create my own form that would contain some text boxes 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 wan to? 

  Thanks in advance,
      Ian Trout
   

  Report abuse