Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
additem to a combobox from other excel worksheet
Hello every body
Can someone help me, I would like to fill a combobox located in an excel whorksheet with th data from other worksheet. Ej Worksheet 1 whit the combobox1 Worksheet 2 with the data (A1:A100) I have tried to initialize but it does not run and thanks in advanc -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
additem to a combobox from other excel worksheet
Private Sub Userform_Initialize()
Combobox1.List = Worksheets("Sheet2").Range("A1:A100").Value End Sub if the combobox is on a worksheet, do it in the workbook open event Private Sub Workbook_Open() Worksheets("Sheet1").Combobox1.List = _ Worksheets("Sheet2").Range("A1:A100").Value End Sub -- Regards, Tom Ogilvy "gelu " wrote in message ... Hello every body Can someone help me, I would like to fill a combobox located in an excel whorksheet with the data from other worksheet. Ej Worksheet 1 whit the combobox1 Worksheet 2 with the data (A1:A100) I have tried to initialize but it does not run and thanks in advance --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox AddItem code to reference cells in a Range | Excel Discussion (Misc queries) | |||
.AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
additem to combobox with an array | Excel Discussion (Misc queries) | |||
Multiple Column ComboBox using Additem | Excel Programming | |||
(Worksheet)Listbox1.additem = (Form)Listbox1.value ?? | Excel Programming |