Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userforms
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userforms
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. -- Regards, Tom Ogilvy "Dave" wrote in message om... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need some help with userforms | Charts and Charting in Excel | |||
I need some help with userforms | Excel Discussion (Misc queries) | |||
UserForms | Excel Discussion (Misc queries) | |||
Userforms | Excel Programming | |||
Userforms | Excel Programming |