Custom VBA Drop Downs

N

Nigel

ok .... so i need to make a custom drop down....

the actual drop down will be nowhere near the data that it is pulling
from (although it will be in the same sheet) so standard list, or
autofilter options are out....

the dropdown needs to list only unique names in a given range

and the range needs to be determined by variables...ie Range("A" & LPS
& ":F" & LPE)
where LPS and LPE are variable row numbers.....

im banging my head against a wall to figure this out......
 
N

Nigel

so i actually made some progress.....

With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=A7:A" &
Range("EndOfProducts").Offset(-1, 0).Row
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = False

so you can see that the range of my validation data is populated by
variables...which is working great...

the problem is...i need to edit it so that my drop down only shows
unique items, and omits any blank cells....

is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
VBA Filter 2
How do I designate dates using info from a cooresponding drop down list? 3
VBA Code to Insert Drop Down List 0
VBA code to link 2 drop down boxes in word 2010 0
drop down lists 2
Search Spreadsheet add to list 1

Top