Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.27 seconds.

  1. Replies
    6
    Views
    222

    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...
  2. Replies
    6
    Views
    222

    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...
  3. 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)...
  4. Replies
    6
    Views
    222

    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...
  5. 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
    ...
  6. 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.
  7. 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...
  8. 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...
  9. 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.
  10. 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...
  11. 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...
  12. Replies
    6
    Views
    222

    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...
  13. 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...
  14. 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?
  15. Replies
    10
    Views
    241

    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.
  16. Replies
    5
    Views
    131

    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
    ...
  17. 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...
  18. Re: Code for inserting a row automatically based on a value in a particular cell

    Not sure what response worked for you sense there were more then one.
    But:
    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  19. Re: Code for inserting a row automatically based on a value in a particular cell

    Normally when using a Template. We never modify the Template after setting it up the way we want.

    If our code modifies the template we always use SaveAs and give the newly created sheet a new...
  20. Re: Manually run VBA on specific cell range

    When writing code for a number of ranges like this we would not write 500 lines of code or more.
    We look for a trend or some rational reasoning why such ranges are chosen.

    So in your example why...
  21. Replies
    2
    Views
    78

    Re: Userform VBA code Generator

    I would like to see you post what you want the UserForm to do for you.

    Like when I click Command Button 1 do this:
    Or If If I select option Button 1 do this:


    I prefer to see written details...
  22. Re: Manually run VBA on specific cell range

    I never open Workbooks of others.

    Your second posting did not help me.

    My script does exactly what you asked for in Post 1


    Or tell me the Range like Range("K135:KMA135")
  23. Re: Manually run VBA on specific cell range

    Not sure why you said:

    There are 1100 ranges in total.

    Your post does not show 1100 ranges

    To perform the script you showed try this:


    Sub Clear_Me()
  24. Re: VBA Code, copy same data multiple times based on user input

    This may be more complicated then I can deal with.

    I like it more when users say here is what I'm doing and here are the results I want to see after the script is run.

    Your explanation had a...
  25. Replies
    12
    Views
    199

    Re: Multiple Toggle Buttons VBA Code

    You said:

    I like this option.

    Which Option are you referring to there are several here.

    My script restricts the code to column A
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4