Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find location of ActiveX control
Check your earlier post.
hjc wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find location of ActiveX control
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. "Dave Peterson" wrote: Check your earlier post. hjc wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
find location of ActiveX control
Awesome, Dave -- thanks! H.J. "Dave Peterson" wrote: 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/microsof...ic.excel.setup news://msnews.microsoft.com/microsoft.public.excel.misc news://msnews.microsoft.com/microsof...heet.functions news://msnews.microsoft.com/microsof...excel.newusers news://msnews.microsoft.com/microsof...el.programming (and a few more for MSWord) news://msnews.microsoft.com/microsof....docmanagement news://msnews.microsoft.com/microsof...word.word97vba news://msnews.microsoft.com/microsof....word.newusers news://msnews.microsoft.com/microsof...ord.pagelayout news://msnews.microsoft.com/microsof...ord.vba.addins news://msnews.microsoft.com/microsof....vba.beginners news://msnews.microsoft.com/microsof....customization news://msnews.microsoft.com/microsof...rd.vba.general news://msnews.microsoft.com/microsof....vba.userforms news://msnews.microsoft.com/microsof....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_tut...e_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_gr...Excel*&num=100 Ron de Bruin has an excel addin that you may like: http://www.rondebruin.nl/Google.htm hjc wrote: 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. "Dave Peterson" wrote: Check your earlier post. hjc wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
find the location of an activeX control | Excel Programming | |||
publish activeX combobox and other activeX control | Excel Programming | |||
How to control "Date Time Picker ActiveX Control" | Excel Programming | |||
ActiveX Control | Excel Programming |