Hello,
I have a userform in my workbook. The userform includes a combo box that relates to an offset range in my main data worksheet. The offset range ("UsedHoldNumber_") is written as: =OFFSET(MAIN!$D$4,0,0,COUNTA('Hold Number'!$D:$D))
I have the following vba written in my userform initialize section:
Please Login or Register to view this content.
How can I make this hide duplicate values and blanks from the combo box?
Thanks in advance,
Bookmarks