 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008find location of ActiveX control
Is there a way to locate an ActiveX control (specifically, a button) in a spreadsheet, i.e., to find out what column it is in? I can figure it out if the control has a linked cell that I can put in the same column, but that doesn't work for a button. Although the 'location' of the left edge of the button is a property of the button, it doesn't seem to correlate to pixels (that could be compared against the sum of the widths of the columns to the left of the control, for example) or anything else, as far as I can tell. I am trying to create a series of buttons, each of which will carry out the same action on the column in which it resides. I am using Excel 2003. Thanks for whatever help anybody can provide! Hugh John Check your earlier post. > Is there a way to locate an ActiveX control (specifically, a button) in a > spreadsheet, i.e., to find out what column it is in? I can figure it out if [quoted text clipped - 9 lines] > Thanks for whatever help anybody can provide! > Hugh John  SignatureDave Peterson Thanks, Dave -- for some reason, my first post 'disappeared' after I submitted it, and I could find no trace of it. In fact, I didn't even think I posted it (at least, not intentionally, nor even accidentally, as far as I was aware), but I suddenly got a message saying that it had been successfully submitted. So, when I couldn't even find it after that, I posted it a second time.... H.J. > Check your earlier post. > [quoted text clipped - 11 lines] > > Thanks for whatever help anybody can provide! > > Hugh John Saved from a previous post: If you have Outlook Express installed, try clicking on these links (or copy and paste into MSIE). news://msnews.microsoft.com/microsoft.public.excel.setup news://msnews.microsoft.com/microsoft.public.excel.misc news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions news://msnews.microsoft.com/microsoft.public.excel.newusers news://msnews.microsoft.com/microsoft.public.excel.programming (and a few more for MSWord) news://msnews.microsoft.com/microsoft.public.word.docmanagement news://msnews.microsoft.com/microsoft.public.word.word97vba news://msnews.microsoft.com/microsoft.public.word.newusers news://msnews.microsoft.com/microsoft.public.word.pagelayout news://msnews.microsoft.com/microsoft.public.word.vba.addins news://msnews.microsoft.com/microsoft.public.word.vba.beginners news://msnews.microsoft.com/microsoft.public.word.vba.customization news://msnews.microsoft.com/microsoft.public.word.vba.general news://msnews.microsoft.com/microsoft.public.word.vba.userforms news://msnews.microsoft.com/microsoft.public.word.word6-7macros (You can always connect to more later) Here are some links that explain it better: Chip Pearson has some notes written by Leonard Meads at: http://www.cpearson.com/excel/DirectConnect.htm David McRitchie's notes at: http://www.mvps.org/dmcritchie/excel/xlnews.htm http://www.mvps.org/dmcritchie/excel/oe6.htm http://www.mvps.org/dmcritchie/excel/oe6nws01.htm Tushar Mehta's notes at: http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm And if you're looking for old posts: Or you can use google (maybe a few hours behind) to search for stuff you've posted (and find the replies, too) http://groups.google.com/advanced_group_search http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100 Ron de Bruin has an excel addin that you may like: http://www.rondebruin.nl/Google.htm > Thanks, Dave -- for some reason, my first post 'disappeared' after I > submitted it, and I could find no trace of it. In fact, I didn't even think [quoted text clipped - 24 lines] > > > > Dave Peterson SignatureDave Peterson Awesome, Dave -- thanks! H.J. > Saved from a previous post: > [quoted text clipped - 73 lines] > > > > > > Dave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.