Search:

Type: Posts; User: My Aswer Is This; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.38 seconds.

  1. Re: Change Worksheet Tab Names based on a cell reference on another worksheet

    If I understand your question correctly you want to be able to enter a sheet name into a Cell on the Template sheet.

    And when you enter that value you want to create a new sheet and a link to that...
  2. Re: Macro: Auto Fill down on Col A & B base on cell

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  3. Re: Macro: Auto Fill down on Col A & B base on cell

    Try this:

    Sub Fill_Down()
    'Modified 8/22/2019 12:30:48 AM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    Dim Lastrow As Long
    Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
    For i = 4...
  4. Replies
    9
    Views
    101

    Re: Help with vba using VlookUp

    Are you saying when you enter "Alpha" in column A of Fees Paid sheet you want the script to look in sheet named Members Column A for "Alpha" and then copy the whole row from sheet Members to sheet...
  5. Re: VBA: Hide columns in one sheet, given the result of a dropdown list in another sheet

    A lot of coding can be done a lot of different ways.

    The line of code in questions will not allow the code to run if you change more then one cell at a time.

    So if you select a Range larger...
  6. Replies
    7
    Views
    168

    Re: Assigning a formula to a button

    If your interested you could use this script which would not require clicking a Button.
    The script runs when you enter a value in Range("B2"

    This is an auto sheet event script
    Your Workbook must...
  7. Replies
    7
    Views
    168

    Re: Assigning a formula to a button

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  8. Replies
    7
    Views
    168

    Re: Assigning a formula to a button

    Try this:

    Private Sub CommandButton1_Click()
    'Modified 8/19/2019 11:08:32 AM EDT
    Select Case Range("B2").Value
    Case "Apple"
    Application.Goto Range("D6"),...
  9. Replies
    6
    Views
    279

    Re: Double Click to activate a macro

    I also asked this question:

    So when you double click on A1 for example what do you want to happen.

    Tell me where you want to double click and when you do so what do you want to happen.

    If...
  10. Replies
    6
    Views
    279

    Re: Double Click to activate a macro

    A asked you this:

    Did you double click on a 5 in column A

    Or Double click on a 2 in column A

    And you did not answer me.

    This might not do what you wanted but your original post was very...
  11. Re: Userform VBA option button get selected option

    You can use this to check all Option Buttons in a UserForm.


    Private Sub CommandButton1_Click()
    'Modified 8/16/2019 11:41:28 PM EDT
    For Each Control In Me.Controls
    If TypeName(Control)...
  12. Replies
    6
    Views
    279

    Re: Double Click to activate a macro

    Did you double click on a 5 in column A

    Or Double click on a 2 in column A

    ??

    That is what my script requires as per my original post.

    This is a example since you never said what you want...
  13. Replies
    7
    Views
    168

    Re: Assigning a formula to a button

    Try this script in your button:

    Private Sub CommandButton1_Click()
    'Modified 8/16/2019 5:47:15 PM EDT
    Select Case Range("B2").Value
    Case "Apple"
    Range("D6").Select
    ...
  14. Re: VBA: Hide columns in one sheet, given the result of a dropdown list in another sheet

    I test all my script and it worked for me.
    The cell value must be exact.
    And the script always looks in Range("F9") on sheet named Summary.

    So it must be January not Jan

    Or change the script.
  15. Re: VBA: Hide columns in one sheet, given the result of a dropdown list in another sheet

    Then my script should work for you.

    Just add the Months and Quarters needded and the columns to hide.

    I did January the way you said in your last post.

    Try this and modify to your needs you...
  16. Re: VBA: Hide columns in one sheet, given the result of a dropdown list in another sheet

    With the limited information you have provide.
    Try this for January and February

    You should be able to do the other Months.

    This is an auto sheet event script
    Your Workbook must be Macro...
  17. Re: VBA: Hide columns in one sheet, given the result of a dropdown list in another sheet

    I could help you but still not sure I see a trend.


    You said:

    If January, then hide columns A, E, J. If February, B, C G...... And so on

    I do not see a trend here.
  18. Re: VBA: Hide columns in one sheet, given the result of a dropdown list in another sheet

    You said:

    then to hide specific columns of my choosing in the "Deposits" sheet.

    How do you plan to this? Do you plan to choose the columns Manually before the script starts?

    So if user...
  19. Re: VBA to create new tab based on each change in....

    I need a more complete explanation.
    You said:

    I have a VBA question. I have a large data set and want to create a new tab based on each change in salesperson.

    Give me a example.

    If you...
  20. Replies
    6
    Views
    279

    Re: Double Click to activate a macro

    Sure a Vba script can be activate using a Double Click.
    But we do not need to use Conditional formatting.

    So when you double click on A1 for example what do you want to happen.

    Tell me where...
  21. Re: Spinning Button carry over to a new row

    Is this your final objective?

    The Command button will add a new row and put the current date on column A1, for example.

    When you say add a new row. Excel already has 1.5 million rows you...
  22. Re: Exporting & Importing Macro with VBA

    Do you know you can put Macros into your Personal Workbook
    And then run the Macro from any Workbook New or Old?
  23. Replies
    10
    Views
    256

    Re: Find Missing Values

    We need specific details.
    Like where is all this data?

    Where is Account Products?
    Where is Avail Products?
    And where is
    Account Product Missing

    And where are these other accounts.
  24. Replies
    5
    Views
    134

    Re: List all subs into listbox

    I would think the easy way would be to load all your Sub's into a ListBox like this.
    And then use this script.


    Private Sub CommandButton1_Click()
    'Modified 8/14/2019 9:17:49 PM EDT
    ...
  25. Re: Copying rows into different 2 different spreadsheets based on 2 colums

    Try this:

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    'Modified 8/14/2019 1:09:20 PM EDT
    If Target.Column = 3 Then
    Cancel = True
    On Error GoTo M
    If...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4