+ Reply to Thread
Results 1 to 3 of 3

Userform VBA Password Box Appears before deleting select data

  1. #1
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    206

    Userform VBA Password Box Appears before deleting select data

    Please advice how can I make below commandbutton1, I need password box appears before the select data delete.



    Private Sub CommandButton1_Click() ' Delete Button
    Dim sil As Long
    If ListBox1.ListIndex = -1 Then
    MsgBox "Choose an entry", vbExclamation
    Exit Sub
    End If
    If ListBox1.ListIndex >= 0 Then
    cevap = MsgBox("Entry will be deleted. ... Are you sure ?", vbYesNo)
    If cevap = vbYes Then
    Sheets("Data").Range("A:A").Find(ListBox1.Text).Activate
    sil = ActiveCell.Row
    Sheets("Data").Rows(sil).Delete

    End If
    End If
    Call Main 'Progress Bar

    For A = 1 To 34

    'Controls("textbox" & A) = ""
    Next


    ListBox1.List = Sheets("Data").Range("a2:AH" & [a65536].End(3).Row).Value
    TextBox36.Value = ListBox1.ListCount
    End Sub

  2. #2
    Registered User
    Join Date
    11-01-2012
    Location
    Cairo, Egypt
    MS-Off Ver
    MS Office 2013
    Posts
    76

    Re: Userform VBA Password Box Appears before deleting select data

    Try the highlighted changes:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    206

    Re: Userform VBA Password Box Appears before deleting select data

    Yes...yes is working

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Password Box Appears After Closing File
    By dmw2014 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-06-2016, 03:04 PM
  2. [SOLVED] Can I Enter the text appears in shape I select into the userform textbox/ listbox/ label?
    By Awni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2016, 07:57 AM
  3. Msg Box appears when Clearing data from Userform
    By flashdisk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2013, 06:32 PM
  4. A password appears when combobox is changed
    By ludovic_44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2012, 11:02 AM
  5. Deleting select data with macro
    By mkingsley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2007, 06:07 PM
  6. Password screen to VBA appears with logging Off
    By James L. Carr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2005, 06:25 PM
  7. DELETING DATA FROM USERFORM
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1