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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jclarkpowereng
-
Excel CommandButton Changes with VBA
That got me where I needed to go. Thank you to all.- jclarkpowereng
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel CommandButton Changes with VBA
Oh yah, and I'm actually trying to assign a section of code (small subroutine) to this button - not actually a macro - just to make things more difficult. Sorry- jclarkpowereng
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel CommandButton Changes with VBA
Thank you, but when I use that snippet, I get a "Run-time error '1004': Unable to set the Text property of the Characters class". Debug stops at: Selection.Characters.Text = "My Text Here" I am using version 6 of Excel VB. Also, I was inserting a CommandButton which...- jclarkpowereng
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel CommandButton Changes with VBA
I am adding a commandbutton to a Excel worksheet with the following command: OutputSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False, DisplayAsIcon:=False, Left:=150, Top:=1330, Width:=200, Height:=50).Select It adds the button and names it...- jclarkpowereng
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Changing CommandButton Properties with VBA
I am adding a commandbutton to a Excel worksheet with the following command: OutputSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False, DisplayAsIcon:=False, Left:=150, Top:=1330, Width:=200, Height:=50).Select It adds the button and names it...- jclarkpowereng
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
