Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    3
    Views
    121

    Re: Find row with multiple matches

    I'm glad to help you. Thanks for the feedback.
  2. Replies
    3
    Views
    90

    Re: VBA Code Editing Help

    Youre welcome! thanks for the feedback
  3. Replies
    9
    Views
    219

    Re: using variables from other macro

    First you must run this macro: inputbox and then this macro: mymsgbox
  4. Replies
    4
    Views
    144

    Re: Help with get hdd serial code

    I'm glad to help you. Thanks for the feedback.
  5. Re: VBA finding a cell based on the value of a pivot table

    What is the range of cells in sheet " Mastertabelle Einzel" where you have your data?

    Saludos a la paisana de México!
  6. Re: VBA - Maybe Looping - Activate Multiple Sheets?

    It already works for you?
  7. Re: Save active worksheet as new workbook havinf the name of the active sheet

    Try this





    Sub sb_Copy_Save_ActiveSheet_As_Workbook()
    Dim wname as string
    Wname = activesheet.name
    ActiveSheet.Copy
  8. Re: Display answer in user form based on value in a workbook

    Im glad to help you, thanks for the feedback!
  9. Re: VBA - Maybe Looping - Activate Multiple Sheets?

    Try this.
    Change "abc" for the password of your sheets.

    Note: All sheets should have the same password, that way we could have a single line for all sheets.


    Sub HideUnhide()
    Dim BeginRow...
  10. Re: VPA problem / Automatic pdf file saved in folder and send out via outlook out of a Print area

    What does the error message say?


    All I see is it could be like this:




    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, _
    Quality:=xlQualityStandard,...
  11. Re: How to print worksheets from a different work book?

    Try this.
    First open the workbook.


    Check the name of the book and its sheets.



    If Range("J15").value=4 then
    Workbooks("receipt file.xlsm").Sheets(array("1","2","3","4")).printout
  12. Re: How to include file names while merging multiple files through VBA

    Welcome to the forum! :)

    Which sheet or which sheets do you want to include?
    Which row or rows, which column or columns?

    So, for example,
    book1, sheet1, range A1:D10
    copy and...
  13. Replies
    4
    Views
    144

    Re: Help with get hdd serial code

    Try this



    If CreateObject("Scripting.FileSystemObject").GetDrive("C:\").SerialNumber <> "1012000350" Then
    MsgBox "Serial number not valid", vbCritical, "Bye"
    Application.Quit
    ...
  14. Re: Multipage-Controls Appear Out of Place/merged

    Check if any of the controls have the Autosize = True property
  15. Re: Display answer in user form based on value in a workbook

    Try



    Private Sub UserForm_Activate()
    If Sheets("Sheet1").Range("F1").Value = 0 Then TextBox1.Value = "Blocked"
    End Sub
  16. Replies
    1
    Views
    73

    Re: Find names based on date

    You need something like this:

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; ...
  17. Re: Excel form Vlookup result ...text box display blank.

    the images are not visible.
    You can put your code and some sample data.


    To put some image:
    :
    https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html
  18. Re: VBA - Maybe Looping - Activate Multiple Sheets?

    I'm glad to help you. I appreciate your kind comments.
  19. Re: Need help to conditionally format a cell in one cell of a table based on the values of two other tables

    The formulas for the format conditions, for red:

    =$A3="No"

    for green.

    =$A3="Yes"

    In applies to:
  20. Replies
    9
    Views
    219

    Re: using variables from other macro

    It is completely normal.
    It should look like this:


    http://tedata.blob.core.windows.net/uploads/md/6ba3c159271b6cb03c893a6594e005be.jpg



    By the way, the declaration of the variable x is...
  21. Re: VBA - Maybe Looping - Activate Multiple Sheets?

    For security, I always set the counter to 1, if you delete a whole row or a column, the macro can enter a loop.
    Change the 1 to say 100 so you can erase about 100 cells.



    Private Sub...
  22. Re: VBA - Maybe Looping - Activate Multiple Sheets?

    Thanks Rick for the good contribution.
  23. Replies
    4
    Views
    82

    Re: Multiple Filter for a Column

    Try this



    Sub Multiple_Filter()
    Dim c As Range, Rng As Range, i As Long, j As Long
    Dim inis() As Variant, outs() As Variant, exists As Boolean
    inis = Array("apple", "orange",...
  24. Replies
    2
    Views
    106

    Re: Multipage Userform

    The answer is yes

    Each textbox or control is unique, no matter what page the control is in, you simply refer to the textbox.

    ie.

    Texbox1 is on page1.
    Textbox17 is on page2.
  25. Re: VBA Script for Copy/Transpose and combine cells - help requested

    You could make it easier for me.
    You can send another file where the column values ​​match the result. Otherwise I do not understand.


    I insist, maybe it's very obvious to you. But I have no...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4