Microsoft Office Excel ® Kod Kılavuzu

Microsoft Office Excel® Code Guide

20 Mart 2005 Pazar

Sound Play

'Module1

Option Explicit
Public Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Sub Sound_Play_Deneme()
On Error Resume Next
Call sndPlaySound32("C:\WINDOWS\Media\Windows Xp Closed", 1)
End Sub

10 Mart 2005 Perşembe

Web Open with WebBrowser1 or ShellExecute Lib





'UserForm1

'AddTools on UserForm1: Label1, TextBox1, CommandButton1, WebBrowser1, Image1, Label2
Option Explicit
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Private Declare Function ShellAbout Lib "shell32.dll" Alias "ShellAboutA" (ByVal hWnd As Long, ByVal szApp As String, ByVal szOtherStuff As String, ByVal hIcon As Long) As Long

Private Sub UserForm_Initialize()
On Error Resume Next
Me.Caption = "[PBİD®] Web Open with WebBrowser1 or ShellExecute Lib..."
TextBox1.Text = http://excelkodklavuzu.blogspot.com/
End Sub
Private Sub CommandButton1_Click()
On Error Resume Next
'ShellExecute 0, "Open", "http://excelkodklavuzu.blogspot.com/", 0&, 0&, 1
WebBrowser1.Navigate TextBox1.Text
End Sub
Private Sub WebBrowser1_BeforeNavigate2(ByVal pDisp As Object, URL As Variant, Flags As Variant, TargetFrameName As Variant, PostData As Variant, Headers As Variant, Cancel As Boolean)
On Error Resume Next
End Sub

1 Mart 2005 Salı

ActiveCell Scrolling

'Module1

Option Explicit

Sub SeçiliHücreninSayfaBaşındaGörünmesi() '[ActiveCell Scrolling]
On Error Resume Next
Application.Goto Reference:=ActiveCell, Scroll:=True
End Sub

Blog Arşivi

Bu gadget'ta bir hata oluştu

Bu Blogda Ara

Contributor

Contributor
Mustafa ULUSARAÇ İstanbul, TÜRKİYE
free counters
T. C. Central Bank Indicative Exchange Rates
Currency Exchange Rate Widget,Currency Converter Widget
Borsa İstanbul