Is there a MrVB?

[exceldvlpr]

I'm developing spreadsheets in excel using control toolbox functions that effect other cells (obviously). I was wondering if anyone knew of a website that could provide me with basic VB source code definitions.
For instance, the code below turns text in a range of cells red and and underlines them when a control toolbox checkbox is checked.
I need to know how to know other basics like how do I make it highlight the whole cell.

Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Range("B14:D14").Font.Color = vbRed
Range("B14:D14").Font.Underline = xlUnderlineStyleSingle
Else
Range("B14:D14").Font.Color = vbBlack
Range("B14:D14").Font.Underline = False

End If
End Sub

[Anne Troy]

http://www.planetsourcecode.com

[Ivan F Moala]

On 2002-05-24 08:18, exceldvlpr wrote:
I'm developing spreadsheets in excel using control toolbox functions that effect other cells (obviously). I was wondering if anyone knew of a website that could provide me with basic VB source code definitions.
For instance, the code below turns text in a range of cells red and and underlines them when a control toolbox checkbox is checked.
I need to know how to know other basics like how do I make it highlight the whole cell.

Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Range("B14:D14").Font.Color = vbRed
Range("B14:D14").Font.Underline = xlUnderlineStyleSingle
Else
Range("B14:D14").Font.Color = vbBlack
Range("B14:D14").Font.Underline = False

End If
End Sub

Hi exceldvlpr, most of the functions/definitions you need
for these controls are avail within excels help files. Just press F1 while in the VBA Editor and Type & search for what you need.
OR search via the Object browser (F2) in the VBA Editor.