Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and read/update option button
I have an Access program that reads and populates an Excel workbook.
However, now I want to be able to read and/or update the values. The workbook has 4 option buttons (radio buttons) that when you click on one, the current selection is turned off. In Access we call this an Option Group. Someone created a template and is no longer available. Thanks. David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and read/update option button
David,
Do you just want to clear the OB from code? xlApp.Activeworkbook.ActiveSheet.OptionButtons("Op tion Button 1").Value = False -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "David Chase" wrote in message ... I have an Access program that reads and populates an Excel workbook. However, now I want to be able to read and/or update the values. The workbook has 4 option buttons (radio buttons) that when you click on one, the current selection is turned off. In Access we call this an Option Group. Someone created a template and is no longer available. Thanks. David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and read/update option button
Actually, I figured out the named range name and used the following and
it works. Thanks. m_objWorkbook.ActiveSheet.Range("wfam").Value = 1 David *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read-only option not appearing on file menu | Excel Discussion (Misc queries) | |||
read-only option not appearing on file menu | Excel Discussion (Misc queries) | |||
read only option | Excel Discussion (Misc queries) | |||
Password Prompt With Read Only Option | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) |