Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tom Ogilvy - 'Snap to'
Tom
How do you know, or where do you find, the ID number? J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tom Ogilvy - 'Snap to'
Try this
http://support.microsoft.com/default...b;EN-US;213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default...11&Product=xlw XL2000: Sample Macros to Return ID for a CommandBar Control -- Regards Ron de Bruin http://www.rondebruin.nl "jngi" wrote in message ... Tom How do you know, or where do you find, the ID number? J |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tom Ogilvy - 'Snap to'
Sub Macro2()
Debug.Print _ CommandBars("Drawing").Controls("D&raw") _ .Controls("&Snap").Controls("To &Grid").ID End Sub or Sub Macro2() MsgBox _ CommandBars("Drawing").Controls("D&raw") _ .Controls("&Snap").Controls("To &Grid").ID End Sub But Ron de Bruin also posted a link to some KB articles that list ID numbers of the controls. -- Regards, Tom Ogilvy "jngi" wrote in message ... Tom How do you know, or where do you find, the ID number? J |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tom Ogilvy - 'Snap to'
MS changed some of the ID numbers between xl97 and xl2000, so here is a
reference to the xl97 verions http://support.microsoft.com/?id=159466 Q159466 - XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/?id=162814 Q162814 - XL97: Sample Macros to Return ID for a CommandBar Control -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Sub Macro2() Debug.Print _ CommandBars("Drawing").Controls("D&raw") _ .Controls("&Snap").Controls("To &Grid").ID End Sub or Sub Macro2() MsgBox _ CommandBars("Drawing").Controls("D&raw") _ .Controls("&Snap").Controls("To &Grid").ID End Sub But Ron de Bruin also posted a link to some KB articles that list ID numbers of the controls. -- Regards, Tom Ogilvy "jngi" wrote in message ... Tom How do you know, or where do you find, the ID number? J |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tom Ogilvy - 'Snap to'
Excellent fellows!
Muchos gracias! "Ron de Bruin" wrote: Try this http://support.microsoft.com/default...b;EN-US;213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default...11&Product=xlw XL2000: Sample Macros to Return ID for a CommandBar Control -- Regards Ron de Bruin http://www.rondebruin.nl "jngi" wrote in message ... Tom How do you know, or where do you find, the ID number? J |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tom Ogilvy - 'Snap to'
Excellent fellows!
Muchos gracias! J "Tom Ogilvy" wrote: Sub Macro2() Debug.Print _ CommandBars("Drawing").Controls("D&raw") _ .Controls("&Snap").Controls("To &Grid").ID End Sub or Sub Macro2() MsgBox _ CommandBars("Drawing").Controls("D&raw") _ .Controls("&Snap").Controls("To &Grid").ID End Sub But Ron de Bruin also posted a link to some KB articles that list ID numbers of the controls. -- Regards, Tom Ogilvy "jngi" wrote in message ... Tom How do you know, or where do you find, the ID number? J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
snap to from vba | Excel Programming | |||
switch on 'snap to' from vba | Excel Programming | |||
Tom Ogilvy | Excel Programming | |||
Tom Ogilvy | Excel Programming | |||
Tom Ogilvy | Excel Programming |