Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdownbox
Hi Alvin
This should work provided there aren't any gaps in your range. If there are, you could record a macro to remove the blanks. You don't say if your dropdown box is on a worksheet or a userform, but if the latter this code should be in the userform_initate() module. dim myCellEnd myCellEnd= Worksheets("name").Range("A1").End _ (xlDown).Address(ROWABSOLUTE:=False) With ComboBox1 .List = Worksheets("SHIFTS").Range("A1:" & myCellEnd) End With -----Original Message----- Hi I have a dropdownboks there takes the vakue from $a$1:$a$12 but some times there are 4 values sometimes 10 an so on but in my dropdownboks I have all the values also the lines there are emty Can't I not tell the dropdownboks only to takes the rows in $a$1:$a$12 where there are values in best regards Alvin . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdownbox | Excel Programming | |||
Dropdownbox | Excel Programming |