userforms

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Need some help (who doesn't).
Need a code for a userform where I pick a value from a combobox,
Pick another value from a second combobox, both values are taken
From a main list on a work sheet, the values represent a begin and an end
Of small list taken from the main list off of the worksheet. Then from
A chosen cell adjacent to the main list, the color of that cell is taken and
Inserted or colored into to the cells adjacent to the small list chosen
from the main list from the range selected from the comboboxes.
 
Are the values dates?

Is the main list sorted, so the two values chose will be on either end of a
contiguous column of cells?


When you say small list, do you want the values from the main list copied
to another location or are you just marking a section of cells in the main
list?

If you want sample code, why not give the range locations for everything so
people don't have to say, assuming the list is in A1:A200 in sheet1 and the
cell with the color is D29.
 
Back
Top