Cell DV Dropdown to UserForm Combobox
Posted on 2011-04-25
If I have a Cell that has a drop-down DV List within it, and a UserForm with a Combobox, designed to replicate what is in that specific cell, how can I transfer those values to a UserForm Combobox, without running through the procedures to regenerate those values?
I tried a frmUser.cbobox = .Cell.Value
It worked in part, but the Combobox showed the entire String to the User.
However, if the Cell shows "123" and the DV has a list of:
Then I'd like the Combobox to show "123" and the entire list available in a drop-down.
Right now, replicating the procedure process of generating the cell values works fine, but it would not seem to be the most efficient way of transferring items from one known source (cell) to another (Combobox). I'm using cells within a 2007 Table if that makes any difference.