| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing data from combo box from VBA
I set up VBA code to acccess data entered into a combo box on an Excel
spreadsheet. The code in the last line is not working and I can't seem to locate the proper command in the Help: Dim cmbComboBox1 As ComboBox Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Registration") Set cmbComboBox1 = ws.ComboBox1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing data from combo box from VBA
wrote:
i.e. Dim cmbComboBox1 As Shape Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Registration") Set cmbComboBox1 = ws.Shapes.Item("ComboBox1") cmbComboBox1.OLEFormat.Object.ListFillRange = Range("A1:A10").Address MsgBox "TopLeftCell" & cmbComboBox1.TopLeftCell.Address .......... -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "rmcompute" wrote: I set up VBA code to acccess data entered into a combo box on an Excel spreadsheet. The code in the last line is not working and I can't seem to locate the proper command in the Help: Dim cmbComboBox1 As ComboBox Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Registration") Set cmbComboBox1 = ws.ComboBox1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing data from combo box from VBA
Thank you. Can you also indicate how to access the data inside the combo box ?
"chijanzen" wrote: wrote: i.e. Dim cmbComboBox1 As Shape Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Registration") Set cmbComboBox1 = ws.Shapes.Item("ComboBox1") cmbComboBox1.OLEFormat.Object.ListFillRange = Range("A1:A10").Address MsgBox "TopLeftCell" & cmbComboBox1.TopLeftCell.Address .......... -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "rmcompute" wrote: I set up VBA code to acccess data entered into a combo box on an Excel spreadsheet. The code in the last line is not working and I can't seem to locate the proper command in the Help: Dim cmbComboBox1 As ComboBox Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Registration") Set cmbComboBox1 = ws.ComboBox1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| accessing data from Access | Excel Discussion (Misc queries) | |||
| accessing graphics with combo box or drop down list | Excel Discussion (Misc queries) | |||
| accessing data in a cell | Excel Programming | |||
| accessing excel combo box control data from vb .net | Excel Programming | |||
| accessing data from an array | Excel Programming | |||
Hybrid Mode
