| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access controls on the spreasheet
I have a combo box on the spreadsheet to let user select the option.
I wanted to print a field base on the combo box. Are there any way to reference the combo box? I tried to use "occurrence " & cmbYear, but I got error. Your help is great appreciated, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access controls on the spreasheet
hi tad sketchy on the details but try this..... assuming the name of your combo box is cmbYear.... cmbYear.value Regards FSt1 "inungh" wrote: I have a combo box on the spreadsheet to let user select the option. I wanted to print a field base on the combo box. Are there any way to reference the combo box? I tried to use "occurrence " & cmbYear, but I got error. Your help is great appreciated, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to access or copy excel form controls (eg. dropdownlist) values to a database | Excel Programming | |||
| Access embedded forms controls from VS2005 | Excel Programming | |||
| Code to access Controls via variables? | Excel Programming | |||
| how to access programatically added controls | Excel Programming | |||
| Accessing ActiveX Controls using VBA - can't use Control.Name to access. | Excel Programming | |||
Linear Mode
