ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   command button question (https://www.excelbanter.com/excel-programming/332217-command-button-question.html)

Gary Keramidas[_2_]

command button question
 
i don't use command buttons very often, but i am wondering why sometimes i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify it.

what's the secret?

--


Gary




Bob Phillips[_6_]

command button question
 
Sounds to me that sometimes you are creating buttons from the forms toolbar,
sometimes from the control toolbox. The former assigns macros to it, and is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why sometimes i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary






Gary Keramidas[_2_]

command button question
 
bob:

i only have problems when using the control toolbox. the forms toolbox is
fine, i just can't modify the color of the buttons using the forms toolbox.
so i try to use the control toolbox and that's where i have problems with
selecting or clicking the buttons.

macros assigned to forms buttons work fine.

--


Gary


"Bob Phillips" wrote in message
...
Sounds to me that sometimes you are creating buttons from the forms
toolbar,
sometimes from the control toolbox. The former assigns macros to it, and
is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why sometimes
i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary








Damon Longworth

command button question
 
Sounds like you are still in "Design mode". There is a green square in the
upper left hand corner of the toolbox. After you are done designing the
button, click on the square to get out of "Design mode".


"Gary Keramidas" wrote in message
...
bob:

i only have problems when using the control toolbox. the forms toolbox is
fine, i just can't modify the color of the buttons using the forms
toolbox. so i try to use the control toolbox and that's where i have
problems with selecting or clicking the buttons.

macros assigned to forms buttons work fine.

--


Gary


"Bob Phillips" wrote in message
...
Sounds to me that sometimes you are creating buttons from the forms
toolbar,
sometimes from the control toolbox. The former assigns macros to it, and
is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why sometimes
i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all 4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary










Bob Phillips[_6_]

command button question
 
As I said in my previous reply, with control toolbox buttons, to modify you
need to be in design mode (click the green-blue triangle button on the
toolbar), and you then you need to exit design mode.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
bob:

i only have problems when using the control toolbox. the forms toolbox is
fine, i just can't modify the color of the buttons using the forms

toolbox.
so i try to use the control toolbox and that's where i have problems with
selecting or clicking the buttons.

macros assigned to forms buttons work fine.

--


Gary


"Bob Phillips" wrote in message
...
Sounds to me that sometimes you are creating buttons from the forms
toolbar,
sometimes from the control toolbox. The former assigns macros to it, and
is
modified by right-clicking and selecting Properties, the latter requires
going into design mode and selecting it to modify its properties.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i don't use command buttons very often, but i am wondering why

sometimes
i
create one, assign an application to run when it's clicked, but noting
happens when i click it. it selects the button with the handles on all

4
corners no matter what i do.

then, sometimes i get it to work, but then i cannot select it to modify

it.

what's the secret?

--


Gary











All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com