Search:

Type: Posts; User: DanteAmor; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds; generated 27 minute(s) ago.

  1. Re: userform - user must enter name to begin

    If you have a button in the userform to save the data on the sheet, there you can put the following:



    Private Sub CommandButton1_Click()
    If TextBox20 = "" Then
    MsgBox "Enter your name",...
  2. Replies
    6
    Views
    126

    Re: WorksheetFunction

    You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook...
  3. Re: Index Match formula with multiple criteria

    Try

    <b>Hoja2</b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  4. Thread: VBA row ?

    by DanteAmor
    Replies
    5
    Views
    146

    Re: VBA row ?

    Try this



    Sub macro()
    Dim c As Range, r As Range
    ActiveSheet.Unprotect
    Set r = Range("B8:B66")
    r.Locked = False
    For Each c In r
  5. Replies
    4
    Views
    91

    Re: Email Code to Email Active XLSX sheet

    Glad to help you, thanks for the feedback.
  6. Replies
    4
    Views
    91

    Re: Email Code to Email Active XLSX sheet

    Try this



    Sub CreateEmail()
    Dim olMail As Object, ws As Worksheet, fName As String
    Set olMail = CreateObject("Outlook.Application").createItem(0)
    Set ws = ActiveSheet
    fName =...
  7. Replies
    3
    Views
    59

    Re: Time format question

    I'm glad to help you. Thanks for the feedback.
  8. Replies
    6
    Views
    126

    Re: WorksheetFunction

    Hi @kuvailondra, welcome to the forum.

    It is a good idea to create, update or delete data from a userform.
    But for that several codes are required. If you like, we help you with the first option:...
  9. Replies
    3
    Views
    59

    Re: Time format question

    I hope this help you.

    =TEXT(H12,"hh:mm am/pm")
  10. Re: Copy Active Cell Comment to next empty row on another worksheet

    Youre welcome:cool:
  11. Re: Copy Active Cell Comment to next empty row on another worksheet

    Because it is a different topic to this thread, please, you could create a new thread.
  12. Re: VBA Code to automate Text To Columns for Row Entries w/ Comma as Delimiter

    Check if this helps you



    ActiveCell(0, -7).Select
    Selection.TextToColumns Destination:=Range(activecell.address), DataType:=xlDelimited, _
    TextQualifier:=xlDoubleQuote,...
  13. Re: Index Match formula with multiple criteria

    Maybe this helps a little.

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  14. Re: Index Match formula with multiple criteria

    Something is not clear in your logic.
    - First, with the examples you gave, it is not known whether to search column A or B for the account.
    - Second, your example for the credit account is not...
  15. Re: Print specific sheets seperately to printer and PDF

    I'm glad to help you. Thanks for the feedback.
  16. Replies
    9
    Views
    219

    Re: Pop up message

    Glad to help you, thanks for the feedback.
  17. Replies
    9
    Views
    219

    Re: Pop up message

    Just copy the complete macro and rename the sheet



    Sub popup()
    Dim lstRow As Long, i As Long, msg As String
    Dim sh As Worksheet
    Set sh = Sheets("Sheet1")
    msg = "The following items...
  18. Replies
    5
    Views
    188

    Re: Sub for keypress check

    I'm glad to help you. Thanks for the feedback.
  19. Re: Clearing Userform Data, After populating "dataSheet" or Getting "Clear Button" to Work on UserForm

    Youre welcome & thanks for the feedback.
  20. Replies
    5
    Views
    188

    Re: Sub for keypress check

    Use this in class module



    Public WithEvents MultTextbox As MSForms.TextBox


    Private Sub MultTextbox_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
    If Not (KeyAscii >= 48 And KeyAscii...
  21. Replies
    3
    Views
    93

    Re: Find end of values in a column

    No problem, let me know if you have any questions. ;)
  22. Thread: VBA row ?

    by DanteAmor
    Replies
    5
    Views
    146

    Re: VBA row ?

    Try this



    Sub macro()
    Dim c As Range
    ActiveSheet.Unprotect
    For Each c In Range("B8:B66")
    If c = "X" Then Range("B" & c.Row & ":M" & c.Row).Locked = True
    Next
  23. Re: Copy Active Cell Comment to next empty row on another worksheet

    Try this





    Sub Copy_Comment()
    Dim c As Range, lr as long
    lr = sheets("sheet2").range("A" & rows.count).end(xlup).row + 1
    For Each c In Sheets("Sheet1").Range("H5:H7")
  24. Re: Macro or other to Search a date and replace with new date with a condition

    Im glad to help you. Thanks for the feedback.
  25. Re: Clearing Userform Data, After populating "dataSheet" or Getting "Clear Button" to Work on UserForm

    you can use vlookup but I recommend using the Find method
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4