+ Reply to Thread
Results 1 to 3 of 3

Button Click Confirmation

  1. #1
    Registered User
    Join Date
    06-17-2015
    Location
    bc, canada
    MS-Off Ver
    2013
    Posts
    4

    Button Click Confirmation

    I do data entry via user form. I would like a message prompting to confirm if the form information is filled out correctly. If yes is clicked, add the data, if no, cancel entry.
    I can't seem to find any information on this. Please help.

    Private Sub cmbSubmit_Click()
    Dim DataEntry As Worksheet

    Set DataEntry = ThisWorkbook.Sheets("Data Entry")

    nr = DataEntry.Cells(Rows.Count, 2).End(xlUp).Row + 1

    DataEntry.Cells(nr, 2) = CDate(Me.tbDate)
    DataEntry.Cells(nr, 3) = Me.cmbMaterial
    DataEntry.Cells(nr, 4) = Me.tbWeight
    DataEntry.Cells(nr, 5) = Me.cmbOrigin
    DataEntry.Cells(nr, 6) = Me.tbDepotTag



    End Sub

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Button Click Confirmation

    Try
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    06-17-2015
    Location
    bc, canada
    MS-Off Ver
    2013
    Posts
    4

    Re: Button Click Confirmation

    Thank you so much.
    You are a saviour, it was exactly what I needed.

+ 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. Button Click on Spreadsheet commanded by Button Click on Userform
    By Quilie19 in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 04-07-2015, 11:35 PM
  2. [SOLVED] click on a color button and after button click it will color entire row of cell you click
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2014, 06:06 PM
  3. clt + C or right click Copy need confirmation in next cell
    By indudhar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-14-2013, 09:10 AM
  4. Call button click event from a button on anther sheet
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-25-2010, 09:27 AM
  5. [SOLVED] [SOLVED] Create floating button based on button click in menu
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2005, 02:05 PM

Tags for this Thread

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