Hi, guys,
1. Can anybody help me to populate ComboBox on VB6 form with
a) text strings from the range on the already existing Excel sheet (e.g., Workbook("Test1 ").Sheets("Shee t1").Range("P12 :P72")) and another ComboBox with
b) names of visible Excel sheets in the same workbook?
2. How to pass selected items from ComboBox1 into Workbook("Test1 ").Sheets("Shee t1").Range("A1" ) and from ComboBox2 into Workbook("Test1 ").Sheets("Shee t1").Range("A2" )?
Your prompt reply is highly appreciated.
1. Can anybody help me to populate ComboBox on VB6 form with
a) text strings from the range on the already existing Excel sheet (e.g., Workbook("Test1 ").Sheets("Shee t1").Range("P12 :P72")) and another ComboBox with
b) names of visible Excel sheets in the same workbook?
2. How to pass selected items from ComboBox1 into Workbook("Test1 ").Sheets("Shee t1").Range("A1" ) and from ComboBox2 into Workbook("Test1 ").Sheets("Shee t1").Range("A2" )?
Your prompt reply is highly appreciated.