Hi,
This maybe simple, but I'm new to VB.
1) Ok, I want to make up a combo box which consists of cell value
B4:B48. Any column can be empty sometimes therefore, the combo bo
should be populated only with non-null values.

2) Also, when the user click on any one of the items from the comb
box, the values of their corresponding rows should be displayed i
their respective textboxs which are already placed on the user form.
For example, if the item on the combo list is 'Soda' (B5) then it
corresponding textboxs for rows 'Close' (C5) & 'Open' (D5) shoul
display its value in the textbox automatically.

Sorry for this mess, I hope you understand what i'm trying to acheiv
:)

- Kkha

--
Message posted from http://www.ExcelForum.com