Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing the values of form controls on worksheets in Excel 2000
Hello,
I have inherited a set of worksheets with about 40 drop down form controls on each worksheet. I need to programatically extract the values from the drop down boxes so that they can be loaded into a database. Unfortunately the creater didn't setup the cell link (Format Control-Control-Cell link) and it doesn't look like it will be practical to update all 150 instances of the spreadsheet with the correct cell links..... :( I have tried to access the drop down boxes through the OLEObjects collection but a count says that there are no OLEobjects on the worksheet. As far as I can tell this is because they are form controls and not controls selected from the control toolbox. 'Debug.Print Worksheets("General details").OLEObjects.Count The drop down boxes are in the shapes collection but I can't do any kind of casting so that I can get them into a control object (or something similar) so that I can get the value. I am using Excel 2000 SR-1. Any help would be appreciated as my manager is keen to find a solution quickly. Regards, Mark ------------------------------------------------ Message posted from http://www.ExcelTip.com/ -- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum -- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/ ------------------------------------------------ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I split form controls in a sheet in excel? | Excel Discussion (Misc queries) | |||
Form controls in Excel 07 | Excel Discussion (Misc queries) | |||
Interaction of form controls and pictures in Excel 2007 | Excel Worksheet Functions | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Accessing ActiveX Controls using VBA - can't use Control.Name to access. | Excel Programming |