LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,202
Default How do I create a control button??

You can either copy the following character from between the parentheses (¼)
and then paste it directly into the Caption property in the Properties
window for the button (yes, I know it doesn't look like three dots, but that
is because the Font in your newsreader is not the Symbol font) or use this
line of code in your own code...

CommandButton1.Caption = Chr$(188)

where I have assumed the name of your button to be CommandButton1 (change
this name to match your actual button's name). Oh, and to reiterate, make
sure you set the Font for the button to the Symbol font.

Rick



"Mekinnik" wrote in message
...
Could you please elaborate on how to assign the Chr$(188) to its Caption
property. I have tried and cannot figure out how to do it. I have Office
2003. I have changed the Font to Symbol and have tried to change the
caption
but have not gotten the results I'm looking for?

"Rick Rothstein (MVP - VB)" wrote:

I think if you change the Font for the button to Symbol and assign (in
code)
Chr$(188) to its Caption property, you will get the three dots.
Alternately,
(after changing the Font to Symbol) you can copy/paste the character
between
the parentheses (¼), which looks like the single character for 1/4 in the
font my newsreader uses, into the Caption property for the button in its
Properties window, you will get the three dots for its Caption.

Rick


"Mekinnik" wrote in message
...
I have been trying to recreate the little button with three dots on it
you
see in the application, but have not been able to do it I can create
the
button but cannot get the three dots to show on it, any thoughts?????




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create control button on worksheet: Forms v. ActiveX feature? [email protected] Excel Discussion (Misc queries) 2 February 16th 08 06:32 AM
create a control button to insert rows nadswilkes28 Excel Discussion (Misc queries) 4 May 15th 07 04:20 AM
Create Control Button Larry Excel Programming 2 October 5th 06 03:43 PM
How do I create a button or control that will automatically go to Roger Excel Worksheet Functions 1 October 29th 04 01:31 AM
create commandbar / control button using codes tango Excel Programming 0 October 26th 04 01:38 AM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"