Prev: Listbox
Next: VLookup in VBA?
From: zzyyzz on 19 Jul 2008 14:50
I got Visual Studio 2003 and Office 2003 on my PC. I created a MS
office system project with Excel template from VS 'New Project' dialog
without changing or adding any code. Then press F5. I can see Excel
shows up, but then disappears instantly.

I also tried to add the following code to ThisWorkbook_Open, and set a
break point. It does not stop at the break point either in debug mode.
Dim Sheet1 As Excel.Worksheet =
ThisWorkbook.Sheets.Item("Sheet1")
Sheet1.Range("A1").Value = "Hello, World!"

Any thought?

Thanks
 | 
Pages: 1
Prev: Listbox
Next: VLookup in VBA?