Retrieving Dropdown/Option Button Values
 

I have a whole slew of excel files that contain data that I want t
compile into a single excel sheet. I've been able to automaticall
grab the values in each file, but am having a terrible time trying t
figure out how to grab the values of form controls. To be precise
few option buttons groups and drop down controls. I know you could d
a cell link then just get the value from there, but unfortunately th
designer didn't do that and I have over a hundred files. I'm prett
much lost. Is there any way to reference the value something like...

excelfile.worksheet.dropdown1.value

I've looked forever trying to find something, but I can't fin
anything. If anyone can point me in the right direction it would b
much appreciated.
Thank

--
entonn
-----------------------------------------------------------------------
entonne's Profile: http://www.excelforum.com/member.php...fo&userid=1503
View this thread: http://www.excelforum.com/showthread.php?threadid=26656

Retrieving Dropdown/Option Button Values
 

for each drpdwn in Activesheet.Dropdowns
svaldrop = drpdwn.Value
' record the result
Next
for each obtn in Activesheet.OptionButtons
if obtn.Value = xlOn then
sValoption = oBtn.Caption
' record the result.
end if
Next

--
Regards,
Tom Ogilvy

"entonne" wrote in message
...

I have a whole slew of excel files that contain data that I want to
compile into a single excel sheet. I've been able to automatically
grab the values in each file, but am having a terrible time trying to
figure out how to grab the values of form controls. To be precise a
few option buttons groups and drop down controls. I know you could do
a cell link then just get the value from there, but unfortunately the
designer didn't do that and I have over a hundred files. I'm pretty
much lost. Is there any way to reference the value something like...

excelfile.worksheet.dropdown1.value

I've looked forever trying to find something, but I can't find
anything. If anyone can point me in the right direction it would be
much appreciated.
Thanks


--
entonne
------------------------------------------------------------------------
entonne's Profile:
http://www.excelforum.com/member.php...o&userid=15039
View this thread: http://www.excelforum.com/showthread...hreadid=266568