PDA

View Full Version : Data for Combo Box: Communicate with another sheet



ashnaveen
08-20-2006, 11:15 PM
Hi
I have a userform with 2 combo boxes - cbotsk and cboPhse.
I want the data for cbotsk to be obtained from another excel file - data.xls.
I have attached the sheets for your reference.

Please help!!!

Thanks in advance
Ash

mdmackillop
08-21-2006, 12:26 AM
No time to answer in detail, but have a look here.
http://www.vbaexpress.com/forum/showthread.php?t=9210

gnod
08-21-2006, 06:30 AM
or you can try this..
http://www.contextures.com/