ⓒ 2025 AI교육연구회 withseok. All rights reserved. (위드석)
[블로그 글 내용 상업적 이용금지] 위드석홈 | 위드석개발 | AI교육연구회

Sub 단추2_Click()

'Selection.Copy

    Dim objData As New DataObject
    Dim strTemp As String

    Dim rng As Range

    strTemp = ""

    For Each rng In Selection
        strTemp = strTemp & rng.Value
    Next rng

    objData.SetText (strTemp)
    objData.PutInClipboard

    Dim WSH As Object
    Set WSH = CreateObject("WScript.Shell")
    WSH.Popup "복사되었습니다!", 1, "Title", vbInformation
        '1은 1초 시간이다.
    Set WSH = Nothing

End Sub
320x100

+ Recent posts