Continue to Site

Welcome to our site!

Electro Tech is an online community (with over 170,000 members) who enjoy talking about and building electronic circuits, projects and gadgets. To participate you need to register. Registration is free. Click here to register now.

  • Welcome to our site! Electro Tech is an online community (with over 170,000 members) who enjoy talking about and building electronic circuits, projects and gadgets. To participate you need to register. Registration is free. Click here to register now.

Vbe - what that "false" means in this code?

Status
Not open for further replies.

atferrari

Well-Known Member
Most Helpful Member
Visual Basic for Excel

In my worksheet I got those 30 shapes and when I run the macro they all get selected.

My question: what the "False" means?
Code:
Sub Macro17()
'
' Macro17 Macro
' Macro grabada el 17/9/2013 por Agustín

    ActiveSheet.Shapes.Range(Array("Oval 1", "Oval 2", "Oval 3", "Oval 4" _
      , "Oval 5", "Oval 6", "Oval 7", "Oval 8" _
      , "Oval 9", "Oval 10", "Oval 11", "Oval 12" _
      , "Oval 13", "Oval 14", "Oval 15", "Oval 16")).Select
    ActiveSheet.Shapes.Range(Array("Oval 17", "Oval 18", "Oval 19", "Oval 20" _
      , "Oval 21", "Oval 22", "Oval 23", "Oval 24" _
      , "Oval 25", "Oval 26", "Oval 27", "Oval 28" _
      , "Oval 29", "Oval 30")).Select False
End Sub

I could not make sense of it.
 
The false tells Excel that you want to add this selection to the previous selection. It's the same as holding down Ctrl when selecting manually.

Mike.
 
Replace False.

Gracias Mike. You always close to those in need of help.
 
Status
Not open for further replies.

Latest threads

New Articles From Microcontroller Tips

Back
Top