Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » CommandButtons via Visual Basic 6.0

CommandButtons via Visual Basic 6.0

From Ashton. When I run this code in a VB6 program, it puts an OLEObject on an Excel sheet. Private Sub Command1_Click()         Dim xlApp As Excel.Application         Set xlApp = Excel.Application     xlApp.Visible = True     xlApp.Workbooks.Add         xlApp.ActiveSheet.OLEObjects.Add "Forms.Commandbutton.1"         Set xlApp = Nothing     [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2008/01/28/commandbuttons-via-visual-basic-60/

Posted Jan 28 2008, 10:04 PM by Daily Dose of Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.