is it possible to apply special effect to command button?

or other alternative...


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=389564

Need more info....

What kind of effects?
How do you want them to work?
???????

--
steveB

Remove "AYN" from email to respond
"ilyaskazi" wrote
in message ...

is it possible to apply special effect to command button?

or other alternative...


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=389564

I don't believe there is any way to change the appearance of controls either
from the Forms toolbar or from the Control Toolbox toolbar without at least
resorting to complex API code. Steve's post seems to imply that he might have
some ideas however, which has me interested.

I wrote a utility a while back that replicates the common 3D special
effects: Raised, Sunken, Etched and Bump. The effects can be applied to
either worksheet cells or to rectangles. I prefer to create my own command
buttons from applying the Raised effect to cell(s) and assigning a macro to
the special effect graphic. The cell text serves as the caption. The command
buttons thus created look identical to those from the Control Tollbox except
you have better control over the text; and the caption can, for that matter,
be a formula and thus change depending on conditions.

Using the same methodology, I suppose you could create different special
effects although I can't think of anything effective. You need to be specific
in what you're trying to achieve.

Regards,
Greg



"ilyaskazi" wrote:


is it possible to apply special effect to command button?

or other alternative...


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=389564

Greg,

You're way ahead of me...

As you pointed out - the secret is in creativity using what already exists
in Excel.

With most controls you can work with the different properties such as color
and font and .....
Throw in the use of shapes, cells, pictures, etc and you have a wide choice
of what you can do.

The trick is figuring out what it is you really want. Most of my projects
entail a fair amount of time finding out what the user really wants...

--
steveB

Remove "AYN" from email to respond
"Greg Wilson" wrote in message
...
I don't believe there is any way to change the appearance of controls
either
from the Forms toolbar or from the Control Toolbox toolbar without at
least
resorting to complex API code. Steve's post seems to imply that he might
have
some ideas however, which has me interested.

I wrote a utility a while back that replicates the common 3D special
effects: Raised, Sunken, Etched and Bump. The effects can be applied to
either worksheet cells or to rectangles. I prefer to create my own command
buttons from applying the Raised effect to cell(s) and assigning a macro
to
the special effect graphic. The cell text serves as the caption. The
command
buttons thus created look identical to those from the Control Tollbox
except
you have better control over the text; and the caption can, for that
matter,
be a formula and thus change depending on conditions.

Using the same methodology, I suppose you could create different special
effects although I can't think of anything effective. You need to be
specific
in what you're trying to achieve.

Regards,
Greg



"ilyaskazi" wrote:


is it possible to apply special effect to command button?

or other alternative...


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread:
http://www.excelforum.com/showthread...hreadid=389564

I doubt very much if I'm ahead of you at all Steve. You probably read a
little too much into my post.

If you add a Label from the Control Toolbox and format its special effect to
raised, then sunken, etched etc., and look at it with a 300% zoom, you can
easily see how they do the graphics. I just replicate this programmatically
using Autoshapes and group them. One wrinkle is that you have to adjust one
of the workbook colours to replicate the button colour. I havn't been able to
do this programmatically since it requires adjustment of Hue, Saturation and
Luminance and not just RGB. This is easily done manually through
ToolsOptionsColor tabModifyCustom tab.

You can use it to replicate a VB form - i.e. apply the raised effect and
button colour to a large range of cells and apply the sunken effect to cells
within the first range to make them appear like text boxes on a user form.
Use the etched effect for frames. Combine this with EnableSelection =
xlUnlockedCells, protect the sheet and it acts like a user form. Good for
making it intuitively obvious where to enter data and you can rely on
formulae instead of code for much of the operation. A change from the usual
if nothing else.

Regards,
Greg




"STEVE BELL" wrote:

Greg,

You're way ahead of me...

As you pointed out - the secret is in creativity using what already exists
in Excel.

With most controls you can work with the different properties such as color
and font and .....
Throw in the use of shapes, cells, pictures, etc and you have a wide choice
of what you can do.

The trick is figuring out what it is you really want. Most of my projects
entail a fair amount of time finding out what the user really wants...

--
steveB

Remove "AYN" from email to respond
"Greg Wilson" wrote in message
...
I don't believe there is any way to change the appearance of controls
either
from the Forms toolbar or from the Control Toolbox toolbar without at
least
resorting to complex API code. Steve's post seems to imply that he might
have
some ideas however, which has me interested.

I wrote a utility a while back that replicates the common 3D special
effects: Raised, Sunken, Etched and Bump. The effects can be applied to
either worksheet cells or to rectangles. I prefer to create my own command
buttons from applying the Raised effect to cell(s) and assigning a macro
to
the special effect graphic. The cell text serves as the caption. The
command
buttons thus created look identical to those from the Control Tollbox
except
you have better control over the text; and the caption can, for that
matter,
be a formula and thus change depending on conditions.

Using the same methodology, I suppose you could create different special
effects although I can't think of anything effective. You need to be
specific
in what you're trying to achieve.

Regards,
Greg



"ilyaskazi" wrote:


is it possible to apply special effect to command button?

or other alternative...


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread:
http://www.excelforum.com/showthread...hreadid=389564

Greg,

I still think you are ahead of me (believe me)

Working with shapes is a problem for me.

But you have reinforced my previous comments -
It's just a matter of thinking "outside the box"...

My motto is to first figure out what you want and than find a way to make
Excel do it...
The list of "can't do" is very small.... and many times you can still find a
way to get there from here...

--
steveB

Remove "AYN" from email to respond
"Greg Wilson" wrote in message
...
I doubt very much if I'm ahead of you at all Steve. You probably read a
little too much into my post.

If you add a Label from the Control Toolbox and format its special effect
to
raised, then sunken, etched etc., and look at it with a 300% zoom, you can
easily see how they do the graphics. I just replicate this
programmatically
using Autoshapes and group them. One wrinkle is that you have to adjust
one
of the workbook colours to replicate the button colour. I havn't been able
to
do this programmatically since it requires adjustment of Hue, Saturation
and
Luminance and not just RGB. This is easily done manually through
ToolsOptionsColor tabModifyCustom tab.

You can use it to replicate a VB form - i.e. apply the raised effect and
button colour to a large range of cells and apply the sunken effect to
cells
within the first range to make them appear like text boxes on a user form.
Use the etched effect for frames. Combine this with EnableSelection =
xlUnlockedCells, protect the sheet and it acts like a user form. Good for
making it intuitively obvious where to enter data and you can rely on
formulae instead of code for much of the operation. A change from the
usual
if nothing else.

Regards,
Greg




"STEVE BELL" wrote:

Greg,

You're way ahead of me...

As you pointed out - the secret is in creativity using what already
exists
in Excel.

With most controls you can work with the different properties such as
color
and font and .....
Throw in the use of shapes, cells, pictures, etc and you have a wide
choice
of what you can do.

The trick is figuring out what it is you really want. Most of my
projects
entail a fair amount of time finding out what the user really wants...

--
steveB

Remove "AYN" from email to respond
"Greg Wilson" wrote in message
...
I don't believe there is any way to change the appearance of controls
either
from the Forms toolbar or from the Control Toolbox toolbar without at
least
resorting to complex API code. Steve's post seems to imply that he
might
have
some ideas however, which has me interested.

I wrote a utility a while back that replicates the common 3D special
effects: Raised, Sunken, Etched and Bump. The effects can be applied to
either worksheet cells or to rectangles. I prefer to create my own
command
buttons from applying the Raised effect to cell(s) and assigning a
macro
to
the special effect graphic. The cell text serves as the caption. The
command
buttons thus created look identical to those from the Control Tollbox
except
you have better control over the text; and the caption can, for that
matter,
be a formula and thus change depending on conditions.

Using the same methodology, I suppose you could create different
special
effects although I can't think of anything effective. You need to be
specific
in what you're trying to achieve.

Regards,
Greg



"ilyaskazi" wrote:


is it possible to apply special effect to command button?

or other alternative...


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread:
http://www.excelforum.com/showthread...hreadid=389564

hey guys,

My objects are on userform. I want to apply special effect to command
button same as we are able to apply other combo box and radio button
from properties.

is it possible in another form?

And yes in between you two i am just novice.

regards,
ilyaskazi


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=389564

There are a number of things you can do with color, font, size, visible,
position, caption
by using code to change the properties.

Just let us know what you are wanting to do...
We can't give you much help until we know what direction to take...

P.S.
And don't worry about being a Novice. We've all been there and
respect that. This group is a great place to be to get more advanced...

--
steveB

Remove "AYN" from email to respond
"ilyaskazi" wrote
in message ...

hey guys,

My objects are on userform. I want to apply special effect to command
button same as we are able to apply other combo box and radio button
from properties.

is it possible in another form?

And yes in between you two i am just novice.

regards,
ilyaskazi


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=389564

On my userform i want to show my command button effect as flat


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=389564

Some controls have properties to control this feature.
I could not find that property for a command button (Excel 2000)

Maybe some one else knows how to do this.

I was able to add a lable and it has a click event.
You could put a lable on your form and use it as a button
and it would have a flat appearance...

Private Sub Label1_Click()
' your code here
End Sub

--
steveB

Remove "AYN" from email to respond
"ilyaskazi" wrote
in message ...

On my userform i want to show my command button effect as flat


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=389564

nice cheat.. thankyou

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=38956

After searching around I was unable to find an example of what I'm
trying to do and, since it's related to special effects type stuff, I
thought I'd add it to this thread.

My form will have 36 check boxes on it. I have created a custom .gif of
the on and off version for it and wanted to use that. Since I can't
change the picture of the standard checkbox, I decided to use either a
command buttton or image type of control.

The problem is that I would have to code for each of the 36 individual
button/image_click events and that's just not good programming (IMO).
So, I'm thinking there should be a way of capturing a click event and
then evaluating what caused it. If it was one of my custom
"checkboxes", then I could run the appropriate code - which basically
sets the tag to true/false and changes the picture.

Am I just not finding what I'm looking for or is it not possible? I was
hoping that if there were a click event and there was no specific
sub/function setup to handle that event, it would travel up the chain
to the next control - IOW, if I put my image controls in a frame and
don't code for the image_click, the frame_click should capture the
click event.

Hope this makes sense.


--
ShosMeister


------------------------------------------------------------------------
ShosMeister's Profile: http://www.excelforum.com/member.php...o&userid=25878
View this thread: http://www.excelforum.com/showthread...hreadid=389564