Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JAD JAD is offline
external usenet poster
 
Posts: 43
Default Toggle Button Format Options

I would like to have more control over the look of a toggle button. At this
point, I have opened and modified items in the Property window only. When the
toggle is depressed, the background color turns black while the font turns
white. When the toggle button is shown as raised, I get a light grid system
over top of the fore mentioned background and font colors. Although I would
like to know all the modifications I can do through VBA on the appearance of
a toggle button, the one change I would like more details on, at this point,
is how to get rid of the grid and replace it with a color change on both
background and font. If you can include any additional changes that I can
use, that would be a bonus. Any help would be appreciated. Thank You, JAD
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 586
Default Toggle Button Format Options

Try checking the BackStyle Property and make sure it is opague. Here is code
that I use for changing the color of a toggle button. Where is the toggle
located a UserForm or Worksheet?

Private Sub tgbStandard_Click()

'changes backcolor and caption of toggle button
If ToggleButton = False Then
With ToggleButton
.Caption = "Manual Off"
.BackColor = vbButtonFace
End With
Else
With ToggleButton
.Caption = "Manual On"
.BackColor = &HC0FFFF 'yellow
End With
End If

End Sub

Hope this helps! If so, let me know and click "YES" below.
--
Cheers,
Ryan


"JAD" wrote:

I would like to have more control over the look of a toggle button. At this
point, I have opened and modified items in the Property window only. When the
toggle is depressed, the background color turns black while the font turns
white. When the toggle button is shown as raised, I get a light grid system
over top of the fore mentioned background and font colors. Although I would
like to know all the modifications I can do through VBA on the appearance of
a toggle button, the one change I would like more details on, at this point,
is how to get rid of the grid and replace it with a color change on both
background and font. If you can include any additional changes that I can
use, that would be a bonus. Any help would be appreciated. Thank You, JAD

Reply
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
Toggle Button ranswrt Excel Programming 2 July 31st 08 04:36 AM
Need to Use 1 Button to toggle On or Off Jim May Excel Discussion (Misc queries) 2 December 1st 07 08:01 PM
Toggle button keithl816 Excel Discussion (Misc queries) 2 November 21st 05 09:16 PM
Toggle Button Dave_2k5[_7_] Excel Programming 4 September 1st 05 10:55 AM
Adding .xla button for Toggle Calculation Button Mike Excel Programming 5 August 19th 05 01:55 PM


All times are GMT +1. The time now is 10:19 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"