User Profile

Collapse

Profile Sidebar

Collapse
Barracuda72
Barracuda72
Last Activity: Nov 6 '19, 08:15 PM
Joined: Nov 4 '19
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Barracuda72
    replied to Macro assigned to an update button
    in Visual Basic .NET
    For all that are interested.... The solution to my issue was
    Code:
      
 If IsEmpty(Range("OrderSummary")) Or IsEmpty(Range("RequestedBy")) Or IsEmpty(Range("POnumber")) Then
 MsgBox "Information is Missing:Requested By, Order Summary, and P.O. Require User Input", vbRetryCancel
 Exit Sub
 End If
    That is all...
    See more | Go to post

      Leave a comment:

    • Barracuda72
      replied to Macro assigned to an update button
      in Visual Basic .NET
      Okay... So I think I have figured part of it out with
      Code:
      If Cells(4, 3).Value = "" Then
MsgBox "Requested By Requires User Input"

Cancel = True
End If
      But I would like this add-on to stop the updating process as well... HELP!!
      Here's entire code with new MsgBox code.
      Code:
      Sub UpdateButton()
  Application.ScreenUpdating = False
  Dim copySheet As Worksheet
  Dim pasteSheet As
      ...
      See more | Go to post
      Last edited by Barracuda72; Nov 4 '19, 06:31 PM. Reason: Add the macro code

        Leave a comment:

      • Barracuda72
        started a topic Macro assigned to an update button
        in Visual Basic .NET

        Macro assigned to an update button

        So.... I have an UpdateButton Macro assigned to my P.O. Generator, and want it to stop and ensure all fields are filled out prior to update.
        Code:
        Sub UpdateButton()
  Application.ScreenUpdating = False
  Dim copySheet As Worksheet
  Dim pasteSheet As Worksheet

  Set copySheet = Worksheets("Purchase Order")
  Set pasteSheet = Worksheets("PO Log")

  copySheet.Range("POnumber").Copy
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...