Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    13
    Views
    404

    Re: Dynamically Rename Worksheet Tabs

    Neat!
  2. Replies
    13
    Views
    404

    Re: Dynamically Rename Worksheet Tabs

    Glad you got it working. Just curious though: you said that you were able to get it to work with OR by enclosing the full statement in brackets but the code you posted shows the use of AND. In my...
  3. Replies
    13
    Views
    404

    Re: Dynamically Rename Worksheet Tabs

    Yes, the logical test should be "AND": if condition is not "Revised" AND is not "Comparison" AND...etc.

    Regards,

    CJ
  4. Replies
    13
    Views
    404

    Re: Dynamically Rename Worksheet Tabs

    A couple changes to catch an invalid year being entered in C4:


    Private Sub CommandButton1_Click()
    Dim yr As String, i As Integer

    yr = Sheets("Revised").Range("C4").Value

    ...
  5. Replies
    13
    Views
    404

    Re: Dynamically Rename Worksheet Tabs

    Hi Sparky:

    Try this is a copy of your workbook:


    Private Sub CommandButton1_Click()
    Dim yr As Integer, i As Integer

    yr = Sheets("Revised").Range("C4").Value
  6. Re: VBA : Change Path or Location A Folder With Automatically

    I'm sorry, I don't understand your question. In your first post you said that your code was working properly and just wanted a way to browse to a certain folder, which is the code I supplied. Please...
  7. Re: VBA : Change Path or Location A Folder With Automatically

    Selamat Petang,

    If you just want the option of selecting the folder before running your code, try this:


    Dim folderspec As String ' Open the Browse Folder dialog
    With...
  8. Replies
    3
    Views
    191

    Re: Selected ListBox Items to sheet

    What you have there should have worked as long as sbClearCells is located in a standard module and not the userform module. You can also use the With...End With statements to clean it up a bit:

    ...
  9. Replies
    3
    Views
    191

    Re: Selected ListBox Items to sheet

    You don't explain the problem you're having. What you have should do what you want. But if you are using the fmMultiSelectSingle property for the listbox you can do away with the loop like so:

    ...
  10. Replies
    10
    Views
    483

    Re: PRI to show when entering text in a cell

    If you're open to using VBA here is a solution:

    Paste the following into the applicable worksheet module (right-click on worksheet tab, select "View Code"):


    Private Sub Worksheet_Change(ByVal...
  11. Replies
    1
    Views
    322

    Re: Excel and Multiple Monitor Issue

    If she is using Windows10 and has the Project mode set to Extend, then when the Excel window is dragged so that the majority of it is on the 2nd monitor, double-click the title bar at the top and it...
  12. Replies
    11
    Views
    1,546

    Re: What should I get paid?

    I figured that would tickle somebody here. :)

    Now...back to those margaritas and some Jimmy Buffet :-P
  13. Replies
    11
    Views
    1,546

    Re: What should I get paid?

    I think what footoo is getting at is that, while your contributions to the online excel community may be (are) impressive, the bottom line is: I ain't paying you more money unless you can prove that...
  14. Replies
    6
    Views
    287

    Re: Vba code to add and copy data needed

    What is the error you are getting? Please post the code from your userform that you are using to call it.
  15. Replies
    6
    Views
    287

    Re: Vba code to add and copy data needed

    Try this:


    Sub CopyAdd()
    Dim Ms As Worksheet, Cs As Worksheet
    Dim x As Integer, y As Integer
    Dim lRow As Long
    Set Ms = ActiveWorkbook.Worksheets("Sheet3")
    Set Cs =...
  16. Replies
    6
    Views
    287

    Re: Vba code to add and copy data needed

    Hi Kelly:

    Try this (change the value of "x To" to reflect how ever many rows you wish to copy/add minus one):


    Sub CopyAdd()
    Dim Ms As Worksheet, Cs As Worksheet
    Dim x As Integer, y...
  17. Re: Run-time Error '1004': Application-defined or object-defined error.

    I can get the same error on that line, but only if there is no data in the worksheet.
  18. Re: Run-time Error '1004': Application-defined or object-defined error.

    Worked okay in my test. So I'm going to point out the probable culprits: Are your workbooks named exactly as you have them in the code? Is FRBO (Private Apt).xls really an .xls file and not .xlsx or...
  19. Replies
    34
    Views
    3,515

    Re: Limit Cursor Movement inside a Userform

    I just tried Dan Elgaard's code in combination with Jafaar's code in post #17 and it worked seamlessly.
  20. Replies
    3
    Views
    175

    Re: ActiveX combo Box

    You're welcome. Thanks for the feedback.
  21. Replies
    3
    Views
    175

    Re: ActiveX combo Box

    You don't need to use the link cell at all. Try this code:


    Private Sub ComboBox1_Change()
    ActiveCell.Value = ComboBox1.Value
    End Sub

    Regards,

    CJ
  22. Re: Feeling really lost. Anyone up for skyping/chatting?

    Here's another suggestion in addition to those already made: since you are dealing with sensitive data, create a new workbook and then, from the VBA editor, drag your VBA modules (all of them...
  23. Thread: Hi

    by MrIfOnly
    Replies
    1
    Views
    900

    Re: Hi

    Welcome to the forum, kowsalyasuresh!
  24. Re: Populate cells from a drop list or combo box

    You can try this after populating your combobox with the names of the named ranges:


    Private Sub ComboBox1_Change()

    Range(ComboBox1.Value).Copy...
  25. Re: Occurrence of first two words and next two and so on

    You're welcome. Thanks for the feedback.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4