Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Recording a macro for drawing a shape in Excel 2007
I need to precise: I'm talking about the shapes in the "Illustrations" box. Btw, "Pictures" and "Shapes" from this box are not recorded, but "ClipArt" and "SmartArt" are. M- bullkater
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Recording a macro for drawing a shape in Excel 2007
Didn't I get the news or what's going on here? When recording macros in Excel 2007, there's no problem until it comes to the recording of the insertion of a shape object or modification of an existing one. Then the recorded macro looks something like this: Sub Macro1() ' ' Macro1...- bullkater
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
"if or then" doesn't work
Thank you all, Andrzejek's tip is working just fine. Thanks again!- bullkater
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
"if or then" doesn't work
Hi everyone, problem: even though the value of one of the two cells is "NA" (and a excel recognizes this) the following dostuff code is executed anyway. Each condition for itself works fine. If Range("V8").Value <> "NA" Or Range("W8").Value <> "NA" Then dostuff End If Does anyone...- bullkater
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
