Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    4
    Views
    64

    KW, I took a look at the source coding for the...

    KW,

    I took a look at the source coding for the site. It is a fairly simple site to initiate the search as the elements are easily identifiable. The resulting "results" page would require an...
  2. Is the code in the main subs for the images...

    Is the code in the main subs for the images similar enough that you need to have only one main sub and within the routine and then cycle through the images?



    Public Sub DoSomething()
    For I =...
  3. How about a sample workbook? Please include what...

    How about a sample workbook? Please include what you want the email to indicate. Do you want instantaneous emails sent when the code is run for just the blank date cells? Are there email addresses...
  4. Replies
    24
    Views
    502

    Vincenzo, Fred actually beat me to your...

    Vincenzo,

    Fred actually beat me to your solution. I wasn't aware we had had the same idea in mind.

    I have adjusted the formulas in Column A to reference values from Column F instead of D. You...
  5. Replies
    24
    Views
    502

    Fred, I didn't open your file but got lost in...

    Fred,

    I didn't open your file but got lost in the wording of your post. Yes, looks like I duplicated your solution. Nicely done!

    Maud
  6. Replies
    24
    Views
    502

    Vincenzo, Here is a variation of RG's...

    Vincenzo,

    Here is a variation of RG's Index/Match formula using a helper column that ranks. The Ranks (column A will handle duplicates by assigning a higher rank to the first instance of the...
  7. Replies
    3
    Views
    92

    bhushanvshah, In your sample, the sheet name...

    bhushanvshah,

    In your sample, the sheet name is EQ290116 which is also one of the names of the files. I will assume that the data on the sheet is all the data contained in one file and that each...
  8. Excel, Below is your code with some changes...

    Excel,

    Below is your code with some changes that I made in blue. The code will now cycle through all the questions when "All" type is selected. I also added some error handling if there are no...
  9. Thread: Delete Button

    by Maudibe
    Replies
    8
    Views
    193

    Yeah, I do it "off and on" as well. :rolleyes:

    Yeah, I do it "off and on" as well. :rolleyes:
  10. =CHOOSE(A1,"July","August","September","October","...

    =CHOOSE(A1,"July","August","September","October","November", etc.) where cell A1 is an integer.
  11. Thread: Delete Button

    by Maudibe
    Replies
    8
    Views
    193

    True zeddy, that is one way. But keeping track...

    True zeddy, that is one way. But keeping track of which ones are visible with all the different names used in the code and varying positions seems much more daunting to me then pairing a caption...
  12. Replies
    2
    Views
    139

    Oops, I see that you have resolved the issue

    Oops, I see that you have resolved the issue
  13. Replies
    2
    Views
    139

    Richard, I have done this many times under...

    Richard,

    I have done this many times under Windows 7 Professional 32 and 64bit editions (note: their destination files are different). See the WS post where I have described the process in...
  14. Replies
    36
    Views
    587

    [SOLVED] Just another reason why I prefer to use VBA over...

    Just another reason why I prefer to use VBA over formulas!
  15. Thread: Delete Button

    by Maudibe
    Replies
    8
    Views
    193

    Z, If Zeddy's approach is what you are looking...

    Z,

    If Zeddy's approach is what you are looking for, then instead of making one visible and hiding the other, why not just have one button then just change the caption and assigned macro? You...
  16. Replies
    36
    Views
    587

    [SOLVED] You're too funny Lou. If you are looking for a...

    You're too funny Lou. If you are looking for a password manager, I use Last Pass. Works perfectly, packed full of features, and totally inexpensive.

    Let me know if I can be of anymore help.
    ...
  17. Replies
    36
    Views
    587

    [SOLVED] Lou, You have a trained eye. I added the...

    Lou,

    You have a trained eye. I added the following code to run when the workbook opens:



    Private Sub UserForm_Activate()
    TextBox1.SetFocus
    TextBox1.CurLine = 0
    TextBox2.SetFocus
  18. Replies
    2
    Views
    84

    Try this line to repopulate your listbox5 with...

    Try this line to repopulate your listbox5 with all 54 rows

    ListBox1.RowSource = "A1:I55"

    HTH,
    Maud
  19. Replies
    36
    Views
    587

    [SOLVED] Lou, UNLOCK THE PROJECT Press Alt-F11 then...

    Lou,

    UNLOCK THE PROJECT
    Press Alt-F11 then double click the VBA Project in the Project window (left top); a password box will open. Enter "LSander5" without the quotes > OK. The project will...
  20. Replies
    36
    Views
    587

    [SOLVED] Lou, You do not have to leave any of the cells...

    Lou,

    You do not have to leave any of the cells unlocked. I have added the following code line to the ThisWorkbook- Workbook_Open event routine that will allow VBA to work on locked cells.


    ...
  21. Replies
    36
    Views
    587

    [SOLVED] Nice pickup Lou. I,LL make the adjustments...

    Nice pickup Lou. I,LL make the adjustments tonight.
  22. If the selection in the combobox is just part of...

    If the selection in the combobox is just part of the contents of what is in the cells in column A then you can use:



    Private Sub ComboBox1_Change()
    ActiveSheet.UsedRange.AutoFilter...
  23. MNN, You can also do something like:...

    MNN,

    You can also do something like:
    =CHOOSE(A1,"January","Febuary","March","April","May", etc.) where cell A1 is an integer.

    HTH,
    Maud
  24. Excel, Try this code in your form to filter...

    Excel,

    Try this code in your form to filter the sheet based on the value of the selection of combobox1.



    Private Sub ComboBox1_Change()
    ActiveSheet.UsedRange.AutoFilter Field:=1,...
  25. Thread: Delete Button

    by Maudibe
    Replies
    8
    Views
    193

    Here is some code from Chip Pearson's web site...

    Here is some code from Chip Pearson's web site that will delete the macro.



    Sub DeleteProcedureFromModule()
    Dim VBProj As VBIDE.VBProject
    Dim VBComp As VBIDE.VBComponent
    Dim...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4