Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find Control toolbox in Office2007
In converting a macro button to the new Office, I cant find any reference to
the above. Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find Control toolbox in Office2007
Add the Developer tab to the ribbon and use Insert on it
To display the Developer tab use Office Button Excel Options...Personalize. See also http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... In converting a macro button to the new Office, I cant find any reference to the above. Can anyone help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find Control toolbox in Office2007
So far so good. In 2003 all I had to do to access the event handler was to
double click on the Button. This is no longer the case. What's the 2007 way of doing it? "Ron de Bruin" wrote: Add the Developer tab to the ribbon and use Insert on it To display the Developer tab use Office Button Excel Options...Personalize. See also http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... In converting a macro button to the new Office, I cant find any reference to the above. Can anyone help? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find Control toolbox in Office2007
In Beta2 TR it is the same and I can't test it in Beta2 now.
Are you sure that you draw a activex button on the sheet ? -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... So far so good. In 2003 all I had to do to access the event handler was to double click on the Button. This is no longer the case. What's the 2007 way of doing it? "Ron de Bruin" wrote: Add the Developer tab to the ribbon and use Insert on it To display the Developer tab use Office Button Excel Options...Personalize. See also http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... In converting a macro button to the new Office, I cant find any reference to the above. Can anyone help? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find Control toolbox in Office2007
I followed your answer to the first post exactly, and it worked. It allowed
me to drop a Button onto the worksheet, which is what I wand because it'll allow me to bring up a form from the worksheet. However I'm a bit at sea with the 2007Beta version in that I dont know how to switch from the default run mode to the design mode. In 2003 you enabled design mode and then doubled clicked on the worksheet button and were brought straight to that event handler thereby allowing one to modify the vba code. "Ron de Bruin" wrote: In Beta2 TR it is the same and I can't test it in Beta2 now. Are you sure that you draw a activex button on the sheet ? -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... So far so good. In 2003 all I had to do to access the event handler was to double click on the Button. This is no longer the case. What's the 2007 way of doing it? "Ron de Bruin" wrote: Add the Developer tab to the ribbon and use Insert on it To display the Developer tab use Office Button Excel Options...Personalize. See also http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... In converting a macro button to the new Office, I cant find any reference to the above. Can anyone help? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find Control toolbox in Office2007
Have test it in Beta2 and in Beta2TR(newest) and in both double clicking the activex button
will bring up the click event in the VBA editor The Design mode option is also on the Developers tab (next to insert) -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... I followed your answer to the first post exactly, and it worked. It allowed me to drop a Button onto the worksheet, which is what I wand because it'll allow me to bring up a form from the worksheet. However I'm a bit at sea with the 2007Beta version in that I dont know how to switch from the default run mode to the design mode. In 2003 you enabled design mode and then doubled clicked on the worksheet button and were brought straight to that event handler thereby allowing one to modify the vba code. "Ron de Bruin" wrote: In Beta2 TR it is the same and I can't test it in Beta2 now. Are you sure that you draw a activex button on the sheet ? -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... So far so good. In 2003 all I had to do to access the event handler was to double click on the Button. This is no longer the case. What's the 2007 way of doing it? "Ron de Bruin" wrote: Add the Developer tab to the ribbon and use Insert on it To display the Developer tab use Office Button Excel Options...Personalize. See also http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... In converting a macro button to the new Office, I cant find any reference to the above. Can anyone help? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I find Control toolbox in Office2007
That worked perfectly. When you said "Add the Developer tab to the ribbon and
use Insert on it", I was saying to myself "Insert what". Then I realised that Insert is a palette of commands containin not just containing form controls but a buch of other very useful functions. Thanks a lot. "Ron de Bruin" wrote: Have test it in Beta2 and in Beta2TR(newest) and in both double clicking the activex button will bring up the click event in the VBA editor The Design mode option is also on the Developers tab (next to insert) -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... I followed your answer to the first post exactly, and it worked. It allowed me to drop a Button onto the worksheet, which is what I wand because it'll allow me to bring up a form from the worksheet. However I'm a bit at sea with the 2007Beta version in that I dont know how to switch from the default run mode to the design mode. In 2003 you enabled design mode and then doubled clicked on the worksheet button and were brought straight to that event handler thereby allowing one to modify the vba code. "Ron de Bruin" wrote: In Beta2 TR it is the same and I can't test it in Beta2 now. Are you sure that you draw a activex button on the sheet ? -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... So far so good. In 2003 all I had to do to access the event handler was to double click on the Button. This is no longer the case. What's the 2007 way of doing it? "Ron de Bruin" wrote: Add the Developer tab to the ribbon and use Insert on it To display the Developer tab use Office Button Excel Options...Personalize. See also http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "abubukarbafaywabalewa" wrote in message ... In converting a macro button to the new Office, I cant find any reference to the above. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control Toolbox | Excel Discussion (Misc queries) | |||
Problem: Control Toolbox Control resizes when clicked | Excel Programming | |||
Control Toolbox | Excel Worksheet Functions | |||
Controls Toolbox control vs Form Toolbox control | Excel Programming | |||
Control Toolbox | Excel Programming |